ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D470B751A9E05362FB09050512 SELECT 'Non Vat' certificate_type, substr(jlz.awt_type_code,1,20) withholding_type, substr(jlz.description,1,30) description, PV_1.vendor_id vendor_id, PV_1.segment1 vendor_number, PV_1.vendor_name supplier_name, PV_1.num_1099||'-'||PV_1.global_attribute12 NIT, ai.invoice_num Document_number, aid.accounting_date Accounting_date, sum(nvl(nvl(aid.base_amount,aid.amount) * (-1),0)) withholding_amount, sum(decode(aid.reversal_flag,'Y', (decode(ABS(nvl(aid.base_amount,aid.amount)* aid.awt_gross_amount), (nvl(aid.base_amount,aid.amount)*aid.awt_gross_amount), ((-1)*aid.awt_gross_amount), aid.awt_gross_amount)), decode(aid.base_amount,NULL, aid.awt_gross_amount, aid.awt_gross_amount*aid.exchange_rate))) Taxable_base_amount, '' Tax_name, hr.global_attribute8 company_name, aid.dist_code_combination_id dist_ccid, cc.chart_of_accounts_id chart_of_accounts, ai.set_of_books_id set_of_books, null C_FLEXDATA, &company_name CF_1, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_desc_all', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') C_desc_all, JL_JLCOPWHR_XMLP_PKG.cf_vat_amountformula('Non Vat', '', PV_1.vendor_id, PV_1.segment1,ai.invoice_num) CF_VAT_AMOUNT FROM po_vendors pv_1, ap_invoices ai, ap_invoice_distributions aid, ap_tax_codes atc, hr_locations hr, gl_code_combinations cc, gl_sets_of_books gl , jl_zz_ap_awt_types jlz WHERE ((aid.global_attribute2 is null and aid.invoice_id = ai.invoice_id and PV_1.vendor_id = ai.vendor_id) or (aid.global_attribute2 = PV_1.segment1 and aid.invoice_id = ai.invoice_id)) AND ai.cancelled_date is NULL AND aid.withholding_tax_code_id = atc.tax_id AND atc.global_attribute4 = jlz.awt_type_code AND gl.set_of_books_id = ai.set_of_books_id AND aid.dist_code_combination_id = cc.code_combination_id AND gl.chart_of_accounts_id = cc.chart_of_accounts_id AND aid.match_status_flag = 'A' AND aid.line_type_lookup_code = 'AWT' AND aid.accounting_date BETWEEN :P_ACCOUNTING_DATE_FROM AND :P_ACCOUNTING_DATE_TO AND atc.global_attribute19 is NULL AND atc.global_attribute4 BETWEEN (nvl(:p_withholding_type_from, atc.global_attribute4)) and (nvl(:p_withholding_type_to, atc.global_attribute4)) &P_Selected_TaxPayerId AND hr.location_id = :C_LOCATION_ID AND &C_WHERE_FLEX GROUP BY jlz.awt_type_code, jlz.description, &P_FLEXDATA, aid.dist_code_combination_id, cc.chart_of_accounts_id, ai.set_of_books_id, PV_1.num_1099||'-'||PV_1.global_attribute12, PV_1.vendor_id, PV_1.vendor_name, ai.invoice_num, aid.accounting_date, hr.global_attribute8, PV_1.segment1 --added ,&company_name ,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') ,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_desc_all', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') UNION ALL SELECT 'VAT' certificate_type, substr(jlz.awt_type_code,1,20) withholding_type, substr(jlz.description,1,30) description, PV_1.vendor_id vendor_id, PV_1.segment1 vendor_number, PV_1.vendor_name supplier_name, PV_1.num_1099||'-'||PV_1.global_attribute12 NIT, ai.invoice_num Document_number, aid.accounting_date Accounting_date, sum(nvl(nvl(aid.base_amount,aid.amount)*(-1),0)) withholding_amount, sum(decode(aid.reversal_flag,'Y', (decode(ABS(nvl(aid.base_amount,aid.amount)* aid.awt_gross_amount), (nvl(aid.base_amount,aid.amount)*aid.awt_gross_amount), ((-1)*aid.awt_gross_amount), aid.awt_gross_amount)), decode(aid.base_amount,NULL, aid.awt_gross_amount, aid.awt_gross_amount*aid.exchange_rate))) Taxable_base_amount, atc.name Tax_name, hr.global_attribute8 company_name, aid.dist_code_combination_id dist_ccid, cc.chart_of_accounts_id chart_of_accounts, ai.set_of_books_id set_of_books, &P_FLEXDATA C_FLEXDATA, &company_name CF_1, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_desc_all', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') C_desc_all, JL_JLCOPWHR_XMLP_PKG.cf_vat_amountformula( 'VAT', atc.name, PV_1.vendor_id, PV_1.segment1,ai.invoice_num) CF_VAT_AMOUNT FROM po_vendors pv_1, ap_invoices ai, ap_invoice_distributions aid, ap_tax_codes atc, hr_locations hr, gl_code_combinations cc, gl_sets_of_books gl , jl_zz_ap_awt_types jlz WHERE ((aid.global_attribute2 is null and aid.invoice_id = ai.invoice_id and PV_1.vendor_id = ai.vendor_id) or (aid.global_attribute2 = PV_1.segment1 and aid.invoice_id = ai.invoice_id)) AND ai.cancelled_date is NULL AND aid.withholding_tax_code_id = atc.tax_id AND atc.global_attribute4 = jlz.awt_type_code AND gl.set_of_books_id = ai.set_of_books_id AND aid.dist_code_combination_id = cc.code_combination_id AND gl.chart_of_accounts_id = cc.chart_of_accounts_id AND aid.match_status_flag = 'A' AND aid.line_type_lookup_code = 'AWT' AND aid.accounting_date BETWEEN :P_ACCOUNTING_DATE_FROM AND :P_ACCOUNTING_DATE_TO AND atc.global_attribute19 is NOT NULL AND atc.global_attribute4 BETWEEN (nvl(:p_withholding_type_from, atc.global_attribute4)) and (nvl(:p_withholding_type_to, atc.global_attribute4)) &P_Selected_TaxPayerId AND hr.location_id = :C_LOCATION_ID AND &C_WHERE_FLEX GROUP BY jlz.awt_type_code, jlz.description, &P_FLEXDATA, aid.dist_code_combination_id, cc.chart_of_accounts_id, ai.set_of_books_id, PV_1.num_1099||'-'||PV_1.global_attribute12, PV_1.vendor_id, PV_1.vendor_name, ai.invoice_num, aid.accounting_date, atc.name, hr.global_attribute8, PV_1.segment1 --added ,&company_name ,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') ,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_desc_all', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') ORDER BY 13 ASC, 16 ASC, 2 ASC, 1 ASC, 3 ASC, 17 ASC, 15 ASC, 14 ASC, 6 ASC, 4 ASC, 7 ASC, 5 ASC, 8 ASC, 2, 17, 7 Y JL JLCOPWHR_XML US JL Colombian Payables Withholding Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Colombian Payables Withholding Report Application: Latin America Localizations Source: Colombian Payables Withholding Report (XML) - Not Supported: Reserved For Future Use Short Name: JLCOPWHR_XML DB package: JL_JLCOPWHR_XMLP_PKG BI Publisher &c_where_flex &company_name &p_flexdata &p_selected_taxpayerid :c_all_segs :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_location_id :c_report_run_time :c_report_start_date :c_where_flex :cp_1 :operating_unit :p_1 :p_accounting_date_from :p_accounting_date_to :p_coa_id :p_conc_request_id :p_end_of_report :p_flexdata :p_min_precision :p_no_data_found :p_period_from :p_period_to :p_segment_high :p_segment_low :p_selected_taxpayerid :p_sob_id :p_tax_name :p_tax_payer_id_from :p_tax_payer_id_to :p_vendor_id :p_vendor_number :p_withholding_type_from :p_withholding_type_to 1 -30 :p_sob_id Char fnd_profile.value('GL_SET_OF_BKS_ID') US Ledger ID Ledger ID 2 -20 :p_coa_id LOV Oracle AP_SRS_COA_ID_BYSOB Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from gl_sets_of_books where set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID') order by value,description SELECT chart_of_accounts_id FROM gl_sets_of_books WHERE set_of_books_id = fnd_profile.value('gl_set_of_bks_id') US Chart of Accounts ID Chart of Accounts ID 3 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 4 10 :p_period_from LOV Oracle AP_SRS_ACCOUNTING_PERIOD_OPT Y select period_name id, period_name value, null description from gl_period_statuses where application_id=200 and adjustment_period_flag<>'Y' and set_of_books_id=fnd_profile.value('gl_set_of_bks_id') order by period_year desc,period_num desc Y US Period From Period From 5 20 :p_period_to LOV Oracle JLCO_AP_PERIOD_TO Y select period_name id, period_name value, null description from gl_period_statuses a where a.start_date>=( select b.start_date from gl_period_statuses b where b.period_name=:$flex$.ap_srs_accounting_period_opt and b.application_id=200 and b.set_of_books_id=fnd_profile.value('gl_set_of_bks_id') ) and a.application_id=200 and a.set_of_books_id=fnd_profile.value('gl_set_of_bks_id') order by period_year desc,period_num desc Y US Period To Period To 6 30 :p_tax_payer_id_to LOV Oracle JLZZ_AP_TAXPAYER_ID Y select nvl(papf.national_identifier,nvl(pv.individual_1099,pv.num_1099)) id, nvl(papf.national_identifier,nvl(pv.individual_1099,pv.num_1099)) value, null description from (select individual_1099,num_1099,employee_id,global_attribute12 from po_vendors) pv,(select distinct person_id,national_identifier from per_all_people_f where trunc(sysdate) between effective_start_date and effective_end_date) papf where nvl(pv.employee_id,-99)=papf.person_id (+) order by nvl(papf.national_identifier,nvl(pv.individual_1099,pv.num_1099)) US Taxpayer ID To Taxpayer ID To 7 40 :p_tax_payer_id_from LOV Oracle JLZZ_AP_TAXPAYER_ID Y select nvl(papf.national_identifier,nvl(pv.individual_1099,pv.num_1099)) id, nvl(papf.national_identifier,nvl(pv.individual_1099,pv.num_1099)) value, null description from (select individual_1099,num_1099,employee_id,global_attribute12 from po_vendors) pv,(select distinct person_id,national_identifier from per_all_people_f where trunc(sysdate) between effective_start_date and effective_end_date) papf where nvl(pv.employee_id,-99)=papf.person_id (+) order by nvl(papf.national_identifier,nvl(pv.individual_1099,pv.num_1099)) US Taxpayer ID From Taxpayer ID From 8 50 :p_withholding_type_from LOV Oracle JLZZ_AP_WITHHOLDING_TYPE Y select awt_type_code id, awt_type_code value, description description from jl_zz_ap_awt_types where nvl(start_date_active,sysdate)<=sysdate and nvl(end_date_active,sysdate)>=sysdate order by awt_type_code US Withholding Type From Withholding Type From 9 60 :p_withholding_type_to LOV Oracle JLZZ_AP_WITHHOLDING_TYPE Y select awt_type_code id, awt_type_code value, description description from jl_zz_ap_awt_types where nvl(start_date_active,sysdate)<=sysdate and nvl(end_date_active,sysdate)>=sysdate order by awt_type_code US Withholding Type To Withholding Type To 10 70 :p_segment_low Char 00-000000-0000-0000-000-0000 US Flexfield From Flexfield From 11 80 :p_segment_high Char 99-999999-9999-9999-999-9999 US Flexfield To Flexfield To