JL Argentine Payables CITI Flat File - Legal - draft

SELECT    det.trx_id				invoice_id,        
  	det.trx_date                                             document_date,
              LPAD(ext.GDF_AP_INVOICES_ATT13, 2, '0')              Document_Type,
             jl_ar_reports_pkg.get_formatted_docnum( det.trx_number )             Document_Num,
              NVL(det.currency_conversion_rate,1)  Exchange_rate,
              RPAD(det.BILLING_TP_NAME, 25, ' ')                    Sup_Name,
	      ext.numeric9 tax_amount,
              det.BILLING_TP_TAXPAYER_ID  CUIT_number,
	det.tax_rate_id, 
	JL_JLARPCFF_XMLP_PKG.cf_acc_dateformula(det.trx_id, det.tax_rate_id) CF_acc_date, 
	JL_JLARPCFF_XMLP_PKG.cf_tax_amountformula(ext.numeric9) CF_Tax_Amount, 
	JL_JLARPCFF_XMLP_PKG.cf_citi_recformula(JL_JLARPCFF_XMLP_PKG.cf_acc_dateformula(det.trx_id, det.tax_rate_id), JL_JLARPCFF_XMLP_PKG.cf_tax_amountformula(ext.numeric9), LPAD ( ext.GDF_AP_INVOICES_ATT13 , 2 , '0' ), jl_ar_reports_pkg.get_formatted_docnum ( det.trx_number ), det.trx_date, det.BILLING_TP_TAXPAYER_ID, RPAD ( det.BILLING_TP_NAME , 25 , ' ' )) CF_citi_rec
FROM    zx_rep_trx_jx_ext_t ext,
        zx_rep_context_t con,
        zx_rep_trx_detail_t det
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     ext.detail_tax_line_id = det.detail_tax_line_id
 GROUP BY           det.trx_id,
		det.trx_date,
                    ext.GDF_AP_INVOICES_ATT13,
                    det.trx_number,
                    det.currency_conversion_rate,
                    det.BILLING_TP_NAME,  
                    det.BILLING_TP_TAXPAYER_ID,
	    ext.numeric9,
	    det.tax_rate_id
ORDER BY det.trx_date,cuit_number,det.trx_number