JL Argentine Payables Perceptions Taken Flat File - draft

Select NVL(actg.accounting_date, det.gl_date) perception_date,
       det.BILLING_TP_TAXPAYER_ID perception_agent_cuit,
       det.trx_number doc_num,
       lpad(substr(det.TAX_REGIME_CODE,1,3),3,'0') DGI_Tax_regime_code ,
       abs(SUM(NVL(det.tax_amt_funcl_curr, det.tax_amt))) perception_amount, 
	JL_JLARPPTF_XMLP_PKG.c_perception_amt_charformula(abs ( SUM ( NVL ( det.tax_amt_funcl_curr , det.tax_amt ) ) )) C_Perception_amt_char, 
	JL_JLARPPTF_XMLP_PKG.doc_numberformula(det.trx_number) DOC_NUMBER
FROM    
         zx_rep_context_t con,
        zx_rep_trx_detail_t det,
	ZX_REP_ACTG_EXT_T   actg
WHERE   con.request_id = :p_conc_request_id
AND     det.request_id = con.request_id
AND     det.rep_context_id = con.rep_context_id
AND     actg.detail_tax_line_id(+) = det.detail_tax_line_id
GROUP BY
    actg.accounting_date,
    det.billing_tp_taxpayer_id,
    det.trx_number,
     det.tax_regime_code,
     det.trx_date,
     det.trx_type_id,
    det.gl_date
ORDER BY det.trx_date, det.trx_type_id, det.trx_number