JL Argentine Receivables Withholding Taken Flat File - draft

➜ Back to Library
Description
Categories: BI Publisher
Application: Latin America Localizations
Source: Argentine Receivables Withholding Taken Flat File (XML) - Not Supported: Reserved For Future Use
Short Name: JLARRWTF_XML
DB package: JL_JLARRWTF_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

Select  lpad( substr(acr.GLOBAL_ATTRIBUTE6,1,3),3,'0') DGI_tax_regime_code, 
            lpad( NVL(replace(substr(cust.JGZZ_FISCAL_CODE,1,10),'-','') || NVL(SUBSTR(cust.GLOBAL_ATTRIBUTE12,1,1),NULL),' ') , 13,' ' ) withholding_agent_cuit, 
            acr.GLOBAL_ATTRIBUTE5   withholding_date , 
            lpad(substr(acr.GLOBAL_ATTRIBUTE4,1,16),16,'0')  withholding_cert_num ,
            acr.amount  withholding_amount, 
	JL_JLARRWTF_XMLP_PKG.cf_with_taken_recformula(lpad ( substr ( acr.GLOBAL_ATTRIBUTE6 , 1 , 3 ) , 3 , '0' ), lpad ( NVL ( replace ( substr ( cust.JGZZ_FISCAL_CODE , 1 , 10 ) , '-' , '' ) || NVL ( SUBSTR ( cust.GLOBAL_ATTRIBUTE12 , 1 , 1 ) , NULL ) , ' ' ) , 13 , ' ' ), acr.GLOBAL_ATTRIBUTE5, lpad ( substr ( acr.GLOBAL_ATTRIBUTE4 , 1 , 16 ) , 16 , '0' ), acr.amount) CF_WITH_TAKEN_REC
FROM  ar_cash_receipts_v acr, 
            hz_parties          cust,
            hz_cust_accounts	custacct,
            fnd_lookups fl     
WHERE acr.gl_date between :P_START_DATE and :P_END_DATE
AND   custacct.cust_account_id = acr.customer_id
AND   custacct.party_id =cust.party_id
and      fl.lookup_type            =  'JLAR_TAX_AUTHORITY_CATEGORY'
and      fl.lookup_code            =   acr.GLOBAL_ATTRIBUTE6
and      fl.meaning  between  :P_WITH_TAX_REGIME_FROM
and      :P_WITH_TAX_REGIME_TO
and      acr.GLOBAL_ATTRIBUTE4  is not null
and      acr.receipt_status     <> 'REV'
order by withholding_date,
               withholding_agent_cuit,
               withholding_cert_num
Parameter Name SQL text Validation
Start Date 
 
 Date
End Date 
 
 Date
Withholding Tax Regime From 
 
 LOV Oracle
Withholding Tax Regime To 
 
 LOV Oracle
Download
 
Related Blitz Reports
CE Cleared Transactions CE General Ledger Reconciliation AR Reversed Receipts AR Reversed Notes Receivable AR Notes Receivable JG Receipt Acknowledgment Letter- Not Supported: Reserved For Future Use AR Work Load Review AR Open Balances Revaluation GL Account Analysis (Distributions)
Blitz Report™

Blitz Report™ provides multiple benefits: