JL Argentine Payables Perceptions Taken Flat File - draft

➜ Back to Library
Description
Categories: BI Publisher
Application: Latin America Localizations
Source: Argentine Payables Perceptions Taken Flat File (XML) - Not Supported: Reserved For Future Use
Short Name: JLARPPTF_XML
DB package: JL_JLARPPTF_XMLP_PKG
Run JL Argentine Payables Perceptions Taken Flat File - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Parameter Name SQL text Validation
Reporting Level 
 
 LOV Oracle
Reporting Context 
 
 LOV Oracle
Company Name 
 
 LOV Oracle
Start Date 
 
 Date
End Date 
 
 Date
VAT Perception Tax Type 
 
 LOV Oracle
Download
Related Blitz Reports
ZX Singaporean Input Taxes Gain/Loss Report- Not Supported: Reserved For Future Use ZX Taiwanese Sales Return and Discount Report- Not Supported: Reserved For Future Use ZX Taiwanese Payables Sales/Purchase Return and Discount Certificate- Not Supported: Reserved For Future Use ZX Taiwanese Pro Forma 401 Report- Not Supported: Reserved For Future Use ZX Singaporean GST F5 Report- Not Supported: Reserved For Future Use ZX Taiwanese Receivables Zero-Rate Tax Report- Not Supported: Reserved For Future Use ZX Tax Reconciliation by Taxable Account Report- Not Supported: Reserved For Future Use ZX Taiwanese Receivables Government Uniform Invoice Report- Not Supported: Reserved For Future Use ZX Taiwanese Input VAT Report- Not Supported: Reserved For Future Use ZX Taiwanese Purchase Return and Discount Report- Not Supported: Reserved For Future Use
Blitz Report™

Blitz Report™ provides multiple benefits: