ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F15D3869E053B46B63588994 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 Y JL JLARRWTF_XML US JL Argentine Receivables Withholding Taken Flat File - draft 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 BI Publisher :applications_template_report :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_chart_of_accounts_id :c_company_name_header :c_nls_all :c_nls_end_of_report :c_nls_na :c_nls_no :c_nls_no_data_exists :c_nls_void :c_nls_yes :c_report_start_date :operating_unit :p_conc_request_id :p_debug_switch :p_end_date :p_min_precision :p_set_of_books_id :p_start_date :p_trace_switch :p_with_tax_regime_from :p_with_tax_regime_to 1 10 :p_start_date Date select sysdate from dual Y US Start Date 2 20 :p_end_date Date select sysdate from dual Y US End Date 3 30 :p_with_tax_regime_from LOV Oracle JLAR_AR_TAX_REGIME Y select meaning id, meaning value, null description from fnd_lookups where lookup_type='JLAR_TAX_AUTHORITY_CATEGORY' and nvl(start_date_active,sysdate)<=sysdate and nvl(end_date_active,sysdate)>=sysdate and enabled_flag='Y' order by meaning Y US Withholding Tax Regime From 4 40 :p_with_tax_regime_to LOV Oracle JLAR_AR_TAX_REGIME Y select meaning id, meaning value, null description from fnd_lookups where lookup_type='JLAR_TAX_AUTHORITY_CATEGORY' and nvl(start_date_active,sysdate)<=sysdate and nvl(end_date_active,sysdate)>=sysdate and enabled_flag='Y' order by meaning Y US Withholding Tax Regime To