Return
Main page
Update
Online help
Desktop
Choice of period :
Day
Week
Month
Year
All
Customized
From
to
(m/d/yy)
Usages of
SELECT
CAST(cte.data -> 'cte' -> 'infCte' -> 'ide' ->> 'nct' AS int8) AS numeroCte, cte.key AS chaveCte, nfe_info.numeroNfe, item.produto ->> 'chave' AS chaveNfe, CAST(cte.data -> 'cte' -> 'infCte' -> 'vprest' ->> 'vtPrest' AS numeric) AS valorPrestacao
FROM
document cte, jsonb_array_elements(cte.data -> 'cte' -> 'infCteNorm' -> 'infDoc' -> 'infNFe') WITH ORDINALITY item(produto), LATERAL (
SELECT
DISTINCT CAST(nfe.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS int8) AS numeroNfe
FROM
document nfe, jsonb_array_elements(nfe.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item_nfe(produto_nfe)
WHERE
nfe.key = item.produto ->> 'chave' AND nfe.data_emissao BETWEEN ? AND ? AND nfe.type IN ('NFE_4_0', 'NFE_3_1', 'NFE_2_0') AND produto_nfe -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'cst' = '06' AND produto_nfe -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'cst' = '06' ) AS nfe_info
WHERE
cte.type = 'CTE' AND cte.cnpj_addressee = ? AND cte.data_emissao BETWEEN ? AND ? AND EXISTS (
SELECT
1
FROM
document nfe, jsonb_array_elements(nfe.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item_nfe(produto_nfe)
WHERE
nfe.key = item.produto ->> 'chave' AND nfe.data_emissao BETWEEN ? AND ? AND nfe.type IN ('NFE_4_0', 'NFE_3_1', 'NFE_2_0') AND produto_nfe -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'cst' = '06' AND produto_nfe -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'cst' = '06' ) limit ?
Request
Find usages
CreditoPisCofinsFreteInsumosAliquotaZeroServiceImpl.consultar
CreditoPisCofinsFreteInsumosAliquotaZeroServiceImpl.consultar
Return
Main page
Update
Online help
Desktop
Day
Week
Month
Year