ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1573869E053B46B63588994 Select jaac.awt_type_code awt_type_code, rtrim(substr(jaac.bank_account_num,1,15),' ')|| ' - '||rtrim(substr(jaac.payment_document_name,1,15),' ')|| ' - '||rtrim(substr(jaac.check_number,1,15),' ') payment_reference, jaac.payment_document_name payment_document_name, jaac.check_number check_number, jaac.certificate_number certificate_number, jaac.certificate_number certificate_number_NUM, jaac.awt_date withholding_date, jaac.tax_name tax_name, (jaac.withholding_amount*(-1) + nvl(jaac.credit_amount,0)) withholding_amount, jaac.credit_amount * (-1) credit_amount, abs(jaac.taxable_base_amount) taxable_base_amount, (jaac.withholding_amount* (-1)) total_awt_amount, jzat.jurisdiction_type jurisdiction_type, jzat.description description, jzat.taxable_base_amount_basis taxable_base_amount_basis, jzat.certificate_header certificate_header, jzat.credit_letter_flag credit_letter_flag, atc.global_attribute7 zone, atc.description description_tax_name, jzat.description withholding_type_description, xle.name Company_name, xle.address_line_1 Company_address_line_1, xle.address_line_2 Company_address_line_2, xle.address_line_3 Company_address_line_3, xle.country||'-'||xle.postal_code||'-'||fl.meaning Company_address_line_4, xle.registration_number CUIT_or_Tax_Id_Number_13, pv1.vendor_name Supplier_Name, pvs.address_line1 Supplier_address_line_1, pvs.address_line2 Supplier_address_line_2, pvs.address_line3 Supplier_address_line_3, pvs.city||' - '||pvs.zip||' - '||pvs.country Supplier_address_line_4, substr(replace(pv1.num_1099,'-'),1,2)||'-'||substr(replace(pv1.num_1099,'-'),3)||'-'||pv1.global_attribute12 Supplier_CUIT, jzat.province_code province_code, xle.registration_number comp_primary_id_number, jzat.tax_authority_id comp_tax_authority_id, jcat.tax_authority_type comp_tax_authority_type, pv1.num_1099 supp_primary_id_number, jzat.tax_authority_id supp_tax_authority_id, jsat.tax_authority_type supp_tax_authority_type, JL_JLARPCWT_XMLP_PKG.cf_payment_amountformula(jaac.check_number) CF_Payment_amount, JL_JLARPCWT_XMLP_PKG.cf_1formula(jzat.jurisdiction_type, jzat.taxable_base_amount_basis, jaac.awt_type_code, jzat.credit_letter_flag) CF_Certificate_type, JL_JLARPCWT_XMLP_PKG.cf_comp_num_agent_retencion7fo(:CF_Certificate_type, xle.registration_number, jzat.tax_authority_id, jcat.tax_authority_type) CF_comp_num_agent_ret, JL_JLARPCWT_XMLP_PKG.cf_supp_province_numberformula(:CF_Certificate_type, pv1.num_1099, jzat.tax_authority_id, jsat.tax_authority_type, jaac.awt_date) CF_supp_province_number, JL_JLARPCWT_XMLP_PKG.province_nameformula(:CF_Certificate_type, jzat.province_code) CF_province_name , JL_JLARPCWT_XMLP_PKG.cf_1formula0039(jaac.awt_type_code, :CERTIFICATE_NUMBER_NUM) CF_UPDATE_CERTIFICATES From jl_zz_ap_supp_awt_types jsat , po_vendor_sites_all pvs, po_vendors pv1, jl_zz_ap_awt_types jzat, jl_ZZ_ap_comp_awt_types jcat, xle_firstparty_information_v xle, ap_tax_codes_all atc, jl_ar_ap_awt_certif_all jaac, fnd_lookups fl where jaac.awt_date >= nvl(:P_DATE_FROM,jaac.awt_date) and jaac.awt_date < = nvl(:P_DATE_TO+1,jaac.awt_date +1) and jaac.status <> 'VOID' and jaac.checkrun_name = nvl(:P_CHECKRUN_NAME,jaac.checkrun_name) and jaac.awt_type_code = nvl(:P_AWT_TYPE_CODE,jaac.awt_type_code) and NVL(jaac.payment_instruction_id,-99) = nvl(:p_payment_instruction, nvl(jaac.payment_instruction_id,-99)) and atc.name = jaac.tax_name and jaac.awt_type_code = jzat.awt_type_code and jcat.awt_type_code = jzat.awt_type_code and pvs.global_attribute17 = 'Y' and pvs.vendor_id = pv1.vendor_id and jsat.awt_type_code = jzat.awt_type_code and jsat.vendor_id = pv1.vendor_id and pv1.vendor_id = jaac.vendor_id and :p_ok_parameter_flag = 'Y' and xle.legal_entity_id = jcat.legal_entity_id(+) and jaac.legal_entity_id = jcat.legal_entity_id &lp_jl_ar_ap_awt_certif_all_wh and fl.lookup_type = 'JLZZ_CITY' and NVL(fl.start_date_active, SYSDATE) <= SYSDATE and NVL(fl.end_date_active, SYSDATE) >= SYSDATE and fl.enabled_flag = 'Y' and fl.lookup_code = xle.town_or_city &P_Selected_Suppliers ORDER BY pv1.vendor_name, jzat.awt_type_code, jaac.certificate_number JL JLARPCWT_XML US JL Argentine Payables Withholding Certificate - draft Application: Latin America Localizations Source: Argentine Payables Withholding Certificate (XML) - Not Supported: Reserved For Future Use Short Name: JLARPCWT_XML DB package: JL_JLARPCWT_XMLP_PKG BI Publisher &lp_jl_ar_ap_awt_certif_all_wh &p_selected_suppliers :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_no :c_nls_no_data_exists :c_nls_yes :c_profile_country_code :c_report_run_time :c_report_start_date :certificate_number_num :cf_certificate_type :lp_jl_ar_ap_awt_certif_all_wh :p_awt_type_code :p_certificate_number :p_checkrun_name :p_conc_request_id :p_date_from :p_date_to :p_debug_switch :p_legal_entity_id :p_min_precision :p_ok_parameter_flag :p_parameter_msg :p_payment_instruction :p_reporting_context :p_reporting_level :p_selected_suppliers :p_supp_num_from :p_supp_num_to :p_supplier_from :p_supplier_id :p_supplier_to 1 10 :p_reporting_level LOV Oracle XLE_LEGAL_REPORTING_LEVEL Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='FND_MO_REPORTING_LEVEL' order by value,description Y US Reporting Level 2 20 :p_reporting_context LOV Oracle XLE_LEGAL_REPORTING_CONTEXT Y select entity_id id, entity_name value, null description from fnd_mo_reporting_entities_v where reporting_level=:$flex$.xle_legal_reporting_level order by value,description Y US Reporting Context 3 30 :p_legal_entity_id LOV Oracle ZX_COMPANY_NAME Y select legal_entity_id id, legal_entity_name value, null description from gl_ledger_le_v where :$flex$.xle_legal_reporting_level='1000' and ledger_id=:$flex$.xle_legal_reporting_context order by value,description US Legal Entity Name 4 40 :p_payment_instruction LOV Oracle IBY_FD_INSTR_REF_NUM Y select payment_instruction_id id, payment_instruction_id value, null description from iby_pay_instructions_all order by payment_instruction_id US Instruction Reference Number 5 50 :p_awt_type_code LOV Oracle JLZZ_AP_WITHHOLDING_TYPE_REP Y select awt_type_code id, awt_type_code value, description description from jl_zz_ap_awt_types order by awt_type_code US Withholding Type Code 6 60 :p_certificate_number LOV Oracle JLAR_AP_AWT_CERTIF_NUMBER_REP Y select certificate_number id, certificate_number value, null description from jl_ar_ap_awt_certif where status<>'VOID' and checkrun_name=nvl(:$flex$.iby_fd_instr_ref_num,checkrun_name) and awt_type_code=nvl(:$flex$.jlzz_ap_withholding_type_rep,awt_type_code) order by certificate_number US Certificate Number 7 70 :p_date_from Date US Start Date 8 80 :p_date_to Date US End Date 9 90 :p_supplier_id LOV Oracle AP_SRS_VENDOR_NAME_NUM Y Y select vendor_id id, vendor_name value, null description from po_vendors order by value,description US Supplier Name 10 100 :p_supplier_from LOV Oracle AP_SRS_VENDOR_NAME_CHAR Y select po.vendor_name id, po.vendor_name value, null description from po_vendors po where po.vendor_id= (select max(po2.vendor_id) from po_vendors po2 where po2.vendor_name=po.vendor_name) order by po.vendor_name US Supplier Name Range From 11 110 :p_supplier_to LOV Oracle AP_SRS_VENDOR_NAME_CHAR Y select po.vendor_name id, po.vendor_name value, null description from po_vendors po where po.vendor_id= (select max(po2.vendor_id) from po_vendors po2 where po2.vendor_name=po.vendor_name) order by po.vendor_name US Supplier Name Range To 12 120 :p_supp_num_from LOV Oracle AP_SRS_VENDOR_NUMBER Y select segment1 id, segment1 value, null description from po_vendors order by segment1 US Supplier Number Range From 13 130 :p_supp_num_to LOV Oracle AP_SRS_VENDOR_NUMBER Y select segment1 id, segment1 value, null description from po_vendors order by segment1 US Supplier Number Range To :$flex$.iby_fd_instr_ref_num Instruction Reference Number Certificate Number :$flex$.jlzz_ap_withholding_type_rep Withholding Type Code Certificate Number :$flex$.xle_legal_reporting_context Reporting Context Legal Entity Name :$flex$.xle_legal_reporting_level Reporting Level Legal Entity Name :$flex$.xle_legal_reporting_level Reporting Level Reporting Context