JL Argentine Payables CITI Flat File - Legal - draft

Description
Categories: BI Publisher
Application: Latin America Localizations
Source: Argentine Payables CITI Flat File - Legal (XML) - Not Supported: Reserved For Future Use
Short Name: JLARPCFF_XML
DB package: JL_JLARPCFF_XMLP_PKG
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
Parameter Name SQL text Validation
Transaction Letter To
 
LOV Oracle
Transaction Letter From
 
LOV Oracle
VAT Tax Type
 
LOV Oracle
End Date
 
Date
Start Date
 
Date
Company Name
 
LOV Oracle
Reporting Context
 
LOV Oracle
Reporting Level
 
LOV Oracle