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 |
