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）限制的操作单元。 54863FF03EA2FD1FE06362FB09051B97Y SELECT rownum N_rownum, x.*, AP_APXT7CMT2_XMLP_PKG.c_error_dummyformula(ERROR_TEXT, VENDOR_NAME) C_error_dummy, AP_APXT7CMT2_XMLP_PKG.cf_negative_miscformula(MISC2, MISC3, MISC4, MISC5, MISC6, MISC7, MISC8, MISC9, MISC10, MISC11/*Bug33372456*/, MISC13, MISC14, MISC15A, MISC15B, ERROR_TEXT, VENDOR_NAME) CF_NEGATIVE_MISC, AP_APXT7CMT2_XMLP_PKG.c_b_recordformula(MISC7, PAYEE_NAME_CONTROL, TIN_TYPE, EIN, VENDOR_ID, MISC1, MISC2, MISC3, MISC4, MISC5, MISC6, MISC8, MISC10, MISC11/*Bug33372456*/, MISC13, MISC14, MISC15A, MISC15B, FOREIGN_PAYEE_FLAG, TAX_REPORTING_NAME, VENDOR_NAME, VENDOR_LINE, VENDOR_CITY, VENDOR_STATE, VENDOR_ZIP, REGION_CODE, MISC9, NEC4) C_B_record FROM ( SELECT rownum C_rownum, pvw.vendor_name vendor_name, pvw.tax_reporting_name tax_reporting_name, rpad(pvw.name_control, 4) payee_name_control, regexp_replace(pvw.address_line1 || ' ' || pvw.address_line2 || ' ' || pvw.address_line3, '[^0-9A-Za-z'' @#$%^&*()_+-=,!\`~{}./?:";''|[][^\]]*', '') vendor_line, decode(substr(pvw.organization_type_lookup_code, 1, 7), 'FOREIGN', substr(pvw.city, 1, 21) || ' ' || substr(pvw.state, 1, 9) || ' ' || substr(ft.territory_short_name, 1, 10), rpad(substr(pvw.city, 1, 40), 40)) vendor_city, rpad(substr(pvw.state, 1, 2), 2) vendor_state, rpad(substr(replace(replace(pvw.zip, '-', ''), ' ', ''), 1, 9), 9) vendor_zip, decode(pvw.address_line1, '', 'No Address Line 1. ') || decode(substr(pvw.organization_type_lookup_code, 1, 7), 'FOREIGN', decode(pvw.country, '', 'No country. '), decode(length(replace(replace(nvl(pvw.national_identifier, nvl(pvw.individual_1099, pvw.num_1099)), '-', ''), ' ', '')), 9, '', 'Bad EIN/SSN. ') || decode(pvw.city, '', 'No city. ') || decode(nvl(pvw.province, pvw.state), '', 'No state. ') || decode(replace(replace(pvw.zip, '-', ''), ' ', ''), '', 'No postal code. ')) error_text, sum(TD.misc1) misc1, sum(TD.misc2) misc2, sum(TD.misc3) misc3, sum(TD.misc4) misc4, sum(TD.misc5) misc5, sum(TD.misc6) misc6, sum(TD.misc7 + TD.misc15aT + TD.misc15b) misc7, sum(TD.misc8) misc8, sum(TD.misc9) misc9, sum(TD.misc10) misc10, sum(TD.misc11) misc11,/*Bug33372456*/ sum(TD.misc13) misc13, sum(TD.misc14) misc14, sum(TD.misc15aT + TD.misc15aNT) misc15a, sum(TD.misc15aT + TD.misc15b) misc15b, decode(substr(pvw.organization_type_lookup_code, 1, 7), 'FOREIGN', '1', ' ') foreign_payee_flag, decode(replace(pvw.organization_type_lookup_code, 'FOREIGN '), 'CORPORATION', '1', 'INDIVIDUAL', '2', ' ') tin_type, decode(replace(replace(nvl(pvw.national_identifier, nvl(pvw.individual_1099, pvw.num_1099)), '-', ''), ' ', ''), '000000000', '', replace(replace(nvl(pvw.national_identifier, nvl(pvw.individual_1099, pvw.num_1099)), '-', ''), ' ', '')) EIN, pvw.segment1 vendor_num, lpad(substr(TD.region_code, 1, 2), 2, '0') region_code, pvw.vendor_id, sum(td.nec4) nec4, CASE WHEN to_char(:P_START_YEAR_DATE, 'YYYY')<2020 THEN (SUM(td.misc1) + SUM(td.misc2) + SUM(td.misc3) + SUM(td.misc5) + SUM(td.misc6) + SUM(td.misc7) + SUM(td.misc15at) + SUM(td.misc15b) + SUM(td.misc8) + SUM(td.misc9) + SUM(td.misc10) + SUM(td.misc11) + SUM(td.misc13) + SUM(td.misc14))/*Bug33372456 - added MISC11*/ ELSE (SUM(td.misc1) + SUM(td.misc2) + SUM(td.misc3) + SUM(td.misc5) + SUM(td.misc6) + 0 + SUM(td.misc8) + SUM(td.misc9) + SUM(td.misc10) + SUM(td.misc11) + SUM(td.misc13) + SUM(td.misc14))/*Bug33372456 - added MISC11*/ END misc_total FROM ap_1099_tape_data TD, fnd_territories_vl ft, (SELECT P.vendor_id VENDOR_ID, P.vendor_name VENDOR_NAME, P.tax_reporting_name TAX_REPORTING_NAME, p.organization_type_lookup_code ORGANIZATION_TYPE_LOOKUP_CODE, NULL NATIONAL_IDENTIFIER, P.individual_1099 INDIVIDUAL_1099, P.num_1099 NUM_1099, pvs.province PROVINCE, pvs.address_line1 ADDRESS_LINE1, pvs.address_line2 ADDRESS_LINE2, pvs.address_line3 ADDRESS_LINE3, pvs.state STATE, pvs.city CITY, pvs.zip ZIP, pvs.COUNTRY COUNTRY, p.segment1 SEGMENT1, p.name_control NAME_CONTROL FROM po_vendors P, po_vendor_sites pvs WHERE pvs.vendor_id = P.vendor_id AND nvl(p.vendor_type_lookup_code, 'DUMMY') <> 'EMPLOYEE' AND (NVL(pvs.tax_reporting_site_flag,'N') = 'Y' OR (pvs.vendor_site_code = (select min(vendor_site_code) from po_vendor_sites pvs2 where pvs2.vendor_id = pvs.vendor_id and nvl(inactive_date, sysdate + 9000) = (select max(decode(inactive_date, '', sysdate + 9000, inactive_date)) from po_vendor_sites pvs3 where pvs3.vendor_id = pvs.vendor_id)) AND not exists (SELECT 'A tax reporting site exists for this vendor' FROM po_vendor_sites pvs4 WHERE NVL(pvs4.tax_reporting_site_flag,'N') = 'Y' AND pvs4.vendor_id = pvs.vendor_id))) UNION ALL SELECT distinct PV.vendor_id VENDOR_ID, Pv.vendor_name VENDOR_NAME, Pv.tax_reporting_name TAX_REPORTING_NAME, pv.organization_type_lookup_code ORGANIZATION_TYPE_LOOKUP_CODE, papf.national_identifier NATIONAL_IDENTIFIER, NULL INDIVIDUAL_1099, NULL NUM_1099, NULL PROVINCE, CASE pvs.vendor_site_code when 'HOME' then per_addr.address_line1 when 'OFFICE' then per_loc.address_line_1 when 'PROVISIONAL' then per_addr_prov.address_line1 else case when per_addr.address_id is NULL then per_loc.address_line_1 else per_addr.address_line1 end end ADDRESS_LINE1, CASE pvs.vendor_site_code when 'HOME' then per_addr.address_line2 when 'OFFICE' then per_loc.address_line_2 when 'PROVISIONAL' then per_addr_prov.address_line2 else case when per_addr.address_id is NULL then per_loc.address_line_2 else per_addr.address_line2 end end ADDRESS_LINE2, CASE pvs.vendor_site_code when 'HOME' then per_addr.address_line3 when 'OFFICE' then per_loc.address_line_3 when 'PROVISIONAL' then per_addr_prov.address_line3 else case when per_addr.address_id is NULL then per_loc.address_line_3 else per_addr.address_line3 end end ADDRESS_LINE3, CASE pvs.vendor_site_code when 'HOME' then case per_addr.style when 'CA' then '' when 'CA_GLB' then '' else NVL(per_addr.region_2, '') end when 'OFFICE' then case per_loc.style when 'CA' then '' when 'CA_GLB' then '' else NVL(per_loc.region_2, '') end when 'PROVISIONAL' then case per_addr_prov.style when 'CA' then '' when 'CA_GLB' then '' else NVL(per_addr_prov.region_2, '') end else case when per_addr.address_id is NULL then case per_loc.style when 'CA' then '' when 'CA_GLB' then '' else NVL(per_loc.region_2, '') end else case per_addr.style when 'CA' then '' when 'CA_GLB' then '' else NVL(per_addr.region_2, '') end end end STATE, CASE pvs.vendor_site_code when 'HOME' then per_addr.town_or_city when 'OFFICE' then per_loc.town_or_city when 'PROVISIONAL' then per_addr_prov.town_or_city else case when per_addr.address_id is NULL then per_loc.town_or_city else per_addr.town_or_city end end CITY, CASE pvs.vendor_site_code when 'HOME' then per_addr.postal_code when 'OFFICE' then per_loc.postal_code when 'PROVISIONAL' then per_addr_prov.postal_code else case when per_addr.address_id is NULL then per_loc.postal_code else per_addr.postal_code end end ZIP, CASE pvs.vendor_site_code when 'HOME' then per_addr.country when 'OFFICE' then per_loc.country when 'PROVISIONAL' then per_addr_prov.country else case when per_addr.address_id is NULL then per_loc.country else per_addr.country end end COUNTRY, pv.segment1 SEGMENT1, pv.name_control NAME_CONTROL FROM HR_LOCATIONS per_loc, PER_ADDRESSES per_addr, PER_ALL_ASSIGNMENTS_F per_assgn, PER_ADDRESSES per_addr_prov, (SELECT distinct papf1.person_id, papf1.national_identifier FROM PER_ALL_PEOPLE_F papf1 WHERE NVL(papf1.effective_end_date,sysdate +9000) = (SELECT MAX(DECODE(papf2.effective_end_date,'',sysdate+9000,papf2.effective_end_date)) FROM PER_ALL_PEOPLE_F papf2 WHERE papf1.person_id=papf2.person_id)) papf, PO_VENDOR_SITES pvs, PO_VENDORS pv WHERE pv.employee_id = papf.person_id AND nvl(pv.vendor_type_lookup_code, 'DUMMY') = 'EMPLOYEE' AND pv.vendor_id = pvs.vendor_id AND pv.employee_id = per_addr.person_id(+) AND per_addr.primary_flag(+) = 'Y' AND SYSDATE BETWEEN per_addr.date_from(+) AND NVL(per_addr.date_to(+), SYSDATE + 1) AND pv.employee_id = per_addr_prov.person_id(+) AND nvl(per_addr_prov.address_type(+),'N') = 'M' AND SYSDATE BETWEEN per_addr_prov.date_from(+) AND NVL(per_addr_prov.date_to(+), SYSDATE + 1) AND pv.employee_id = per_assgn.person_id(+) AND per_assgn.location_id = per_loc.location_id(+) AND per_assgn.assignment_type(+) = 'E' AND per_assgn.primary_flag(+) = 'Y' AND (TRUNC(SYSDATE) BETWEEN per_assgn.effective_start_date(+) AND per_assgn.effective_end_date(+)) AND (NVL(pvs.tax_reporting_site_flag,'N') = 'Y' OR (pvs.vendor_site_code = (select min(vendor_site_code) from po_vendor_sites pvs2 where pvs2.vendor_id = pvs.vendor_id and nvl(inactive_date, sysdate + 9000) = (select max(decode(inactive_date, '', sysdate + 9000, inactive_date)) from po_vendor_sites pvs3 where pvs3.vendor_id = pvs.vendor_id)) AND not exists (SELECT 'A tax reporting site exists for this vendor' FROM po_vendor_sites pvs4 WHERE NVL(pvs4.tax_reporting_site_flag,'N') = 'Y' AND pvs4.vendor_id = pvs.vendor_id)))) pvw WHERE TD.vendor_id = pvw.vendor_id AND pvw.vendor_id IN (SELECT X.vendor_id FROM ap_1099_tape_data X GROUP BY vendor_id HAVING sum(nvl(misc1, 0)) + sum(nvl(misc3, 0)) + sum(nvl(misc6, 0)) + sum(nvl(misc7, 0)) + sum(nvl(misc9, 0)) + sum(nvl(misc10, 0)) + sum(nvl(misc11, 0)) >= :P_FEDERAL_REPORTING_LIMIT/*Bug33372456*/ OR sum(nvl(misc2, 0)) >= 10 OR sum(nvl(misc8, 0)) >= 10 OR sum(nvl(misc15aT, 0)) + sum(nvl(misc15aNT, 0)) >= :P_FEDERAL_REPORTING_LIMIT OR sum(nvl(misc13, 0)) + sum(nvl(misc14, 0)) + sum(nvl(misc5, 0)) > 0 OR sum(nvl(misc15b, 0)) > 0 OR sum(nvl(misc4, 0)) > 0 OR sum(nvl(misc11, 0)) >= :P_FEDERAL_REPORTING_LIMIT/*Bug33372456*/ UNION SELECT Y.vendor_id FROM ap_1099_tape_data Y WHERE region_code is not null) AND nvl(misc1, 0) + nvl(misc2, 0) + nvl(misc3, 0) + nvl(misc4, 0) + nvl(misc5, 0) + nvl(misc6, 0) + nvl(misc7, 0) + nvl(misc8, 0) + nvl(misc9, 0) + nvl(misc10, 0) + nvl(misc13, 0) + nvl(misc14, 0) + nvl(misc15aT, 0) + nvl(misc15aNT, 0) + nvl(misc15b, 0) + nvl(misc11, 0)/*Bug33372456*/ > 0 AND ft.territory_code(+) = pvw.country GROUP BY rownum, pvw.vendor_name, TD.region_code, pvw.name_control, pvw.organization_type_lookup_code, nvl(pvw.national_identifier, nvl(pvw.individual_1099, pvw.num_1099)), pvw.segment1, pvw.tax_reporting_name, pvw.country, ft.territory_short_name, pvw.address_line1, pvw.address_line2, pvw.address_line3, pvw.city, pvw.province, pvw.state, pvw.zip, pvw.vendor_id ORDER BY 1) x WHERE (x.misc_total> 0 OR to_char(:P_START_YEAR_DATE, 'YYYY')<2020) AND :P_RETURN_TYPE = 'MISC' UNION ALL SELECT rownum N_rownum, x.*, AP_APXT7CMT2_XMLP_PKG.c_error_dummyformula(N_ERROR_TEXT, N_VENDOR_NAME) C_error_dummy, AP_APXT7CMT2_XMLP_PKG.cf_negative_miscformula(N_MISC2, N_MISC3, N_MISC4, N_MISC5, N_MISC6, N_MISC7, N_MISC8, N_MISC9, N_MISC10, N_MISC11/*Bug33372456*/, N_MISC13, N_MISC14, N_MISC15A, N_MISC15B, N_ERROR_TEXT, N_VENDOR_NAME) CF_NEGATIVE_MISC, AP_APXT7CMT2_XMLP_PKG.c_b_recordformula(N_MISC7, N_PAYEE_NAME_CONTROL, N_TIN_TYPE, N_EIN, N_VENDOR_ID, N_MISC1, N_MISC2, N_MISC3, N_MISC4, N_MISC5, N_MISC6, N_MISC8, N_MISC10, N_MISC11/*Bug33372456*/, N_MISC13, N_MISC14, N_MISC15A, N_MISC15B, N_FOREIGN_PAYEE_FLAG, N_TAX_REPORTING_NAME, N_VENDOR_NAME, N_VENDOR_LINE, N_VENDOR_CITY, N_VENDOR_STATE, N_VENDOR_ZIP, N_REGION_CODE, N_MISC9, N_NEC4) C_B_record FROM ( SELECT rownum N_rownum, pvw.vendor_name n_vendor_name, pvw.tax_reporting_name n_tax_reporting_name, rpad(pvw.name_control, 4) n_payee_name_control, regexp_replace(pvw.address_line1 || ' ' || pvw.address_line2 || ' ' || pvw.address_line3, '[^0-9A-Za-z'' @#$%^&*()_+-=,!\`~{}./?:";''|[][^\]]*', '') n_vendor_line, decode(substr(pvw.organization_type_lookup_code, 1, 7), 'FOREIGN', substr(pvw.city, 1, 21) || ' ' || substr(pvw.state, 1, 9) || ' ' || substr(ft.territory_short_name, 1, 10), rpad(substr(pvw.city, 1, 40), 40)) n_vendor_city, rpad(substr(pvw.state, 1, 2), 2) n_vendor_state, rpad(substr(replace(replace(pvw.zip, '-', ''), ' ', ''), 1, 9), 9) n_vendor_zip, decode(pvw.address_line1, '', 'No Address Line 1. ') || decode(substr(pvw.organization_type_lookup_code, 1, 7), 'FOREIGN', decode(pvw.country, '', 'No country. '), decode(length(replace(replace(nvl(pvw.national_identifier, nvl(pvw.individual_1099, pvw.num_1099)), '-', ''), ' ', '')), 9, '', 'Bad EIN/SSN. ') || decode(pvw.city, '', 'No city. ') || decode(nvl(pvw.province, pvw.state), '', 'No state. ') || decode(replace(replace(pvw.zip, '-', ''), ' ', ''), '', 'No postal code. ')) n_error_text, sum(TD.misc1) n_misc1, sum(TD.misc2) n_misc2, sum(TD.misc3) n_misc3, sum(TD.misc4) n_misc4, sum(TD.misc5) n_misc5, sum(TD.misc6) n_misc6, sum(TD.misc7 + TD.misc15aT + TD.misc15b) n_misc7, sum(TD.misc8) n_misc8, sum(TD.misc9) n_misc9, sum(TD.misc10) n_misc10, sum(TD.misc11) n_misc11,/*Bug33372456*/ sum(TD.misc13) n_misc13, sum(TD.misc14) n_misc14, sum(TD.misc15aT + TD.misc15aNT) n_misc15a, sum(TD.misc15aT + TD.misc15b) n_misc15b, decode(substr(pvw.organization_type_lookup_code, 1, 7), 'FOREIGN', '1', ' ') n_foreign_payee_flag, decode(replace(pvw.organization_type_lookup_code, 'FOREIGN '), 'CORPORATION', '1', 'INDIVIDUAL', '2', ' ') n_tin_type, decode(replace(replace(nvl(pvw.national_identifier, nvl(pvw.individual_1099, pvw.num_1099)), '-', ''), ' ', ''), '000000000', '', replace(replace(nvl(pvw.national_identifier, nvl(pvw.individual_1099, pvw.num_1099)), '-', ''), ' ', '')) n_EIN, pvw.segment1 n_vendor_num, /* NULL n_region_code, Bug33372456 commented and added below*/ lpad(substr(TD.region_code, 1, 2), 2, '0') n_region_code, pvw.vendor_id n_vendor_id, sum(td.nec4) n_nec4, NULL misc_total FROM ap_1099_tape_data TD, fnd_territories_vl ft, (SELECT P.vendor_id VENDOR_ID, P.vendor_name VENDOR_NAME, P.tax_reporting_name TAX_REPORTING_NAME, p.organization_type_lookup_code ORGANIZATION_TYPE_LOOKUP_CODE, NULL NATIONAL_IDENTIFIER, P.individual_1099 INDIVIDUAL_1099, P.num_1099 NUM_1099, pvs.province PROVINCE, pvs.address_line1 ADDRESS_LINE1, pvs.address_line2 ADDRESS_LINE2, pvs.address_line3 ADDRESS_LINE3, pvs.state STATE, pvs.city CITY, pvs.zip ZIP, pvs.COUNTRY COUNTRY, p.segment1 SEGMENT1, p.name_control NAME_CONTROL FROM po_vendors P, po_vendor_sites pvs WHERE pvs.vendor_id = P.vendor_id AND nvl(p.vendor_type_lookup_code, 'DUMMY') <> 'EMPLOYEE' AND (NVL(pvs.tax_reporting_site_flag,'N') = 'Y' OR (pvs.vendor_site_code = (select min(vendor_site_code) from po_vendor_sites pvs2 where pvs2.vendor_id = pvs.vendor_id and nvl(inactive_date, sysdate + 9000) = (select max(decode(inactive_date, '', sysdate + 9000, inactive_date)) from po_vendor_sites pvs3 where pvs3.vendor_id = pvs.vendor_id)) AND not exists (SELECT 'A tax reporting site exists for this vendor' FROM po_vendor_sites pvs4 WHERE NVL(pvs4.tax_reporting_site_flag,'N') = 'Y' AND pvs4.vendor_id = pvs.vendor_id))) UNION ALL SELECT distinct PV.vendor_id VENDOR_ID, Pv.vendor_name VENDOR_NAME, Pv.tax_reporting_name TAX_REPORTING_NAME, pv.organization_type_lookup_code ORGANIZATION_TYPE_LOOKUP_CODE, papf.national_identifier NATIONAL_IDENTIFIER, NULL INDIVIDUAL_1099, NULL NUM_1099, NULL PROVINCE, CASE pvs.vendor_site_code when 'HOME' then per_addr.address_line1 when 'OFFICE' then per_loc.address_line_1 when 'PROVISIONAL' then per_addr_prov.address_line1 else case when per_addr.address_id is NULL then per_loc.address_line_1 else per_addr.address_line1 end end ADDRESS_LINE1, CASE pvs.vendor_site_code when 'HOME' then per_addr.address_line2 when 'OFFICE' then per_loc.address_line_2 when 'PROVISIONAL' then per_addr_prov.address_line2 else case when per_addr.address_id is NULL then per_loc.address_line_2 else per_addr.address_line2 end end ADDRESS_LINE2, CASE pvs.vendor_site_code when 'HOME' then per_addr.address_line3 when 'OFFICE' then per_loc.address_line_3 when 'PROVISIONAL' then per_addr_prov.address_line3 else case when per_addr.address_id is NULL then per_loc.address_line_3 else per_addr.address_line3 end end ADDRESS_LINE3, CASE pvs.vendor_site_code when 'HOME' then case per_addr.style when 'CA' then '' when 'CA_GLB' then '' else NVL(per_addr.region_2, '') end when 'OFFICE' then case per_loc.style when 'CA' then '' when 'CA_GLB' then '' else NVL(per_loc.region_2, '') end when 'PROVISIONAL' then case per_addr_prov.style when 'CA' then '' when 'CA_GLB' then '' else NVL(per_addr_prov.region_2, '') end else case when per_addr.address_id is NULL then case per_loc.style when 'CA' then '' when 'CA_GLB' then '' else NVL(per_loc.region_2, '') end else case per_addr.style when 'CA' then '' when 'CA_GLB' then '' else NVL(per_addr.region_2, '') end end end STATE, CASE pvs.vendor_site_code when 'HOME' then per_addr.town_or_city when 'OFFICE' then per_loc.town_or_city when 'PROVISIONAL' then per_addr_prov.town_or_city else case when per_addr.address_id is NULL then per_loc.town_or_city else per_addr.town_or_city end end CITY, CASE pvs.vendor_site_code when 'HOME' then per_addr.postal_code when 'OFFICE' then per_loc.postal_code when 'PROVISIONAL' then per_addr_prov.postal_code else case when per_addr.address_id is NULL then per_loc.postal_code else per_addr.postal_code end end ZIP, CASE pvs.vendor_site_code when 'HOME' then per_addr.country when 'OFFICE' then per_loc.country when 'PROVISIONAL' then per_addr_prov.country else case when per_addr.address_id is NULL then per_loc.country else per_addr.country end end COUNTRY, pv.segment1 SEGMENT1, pv.name_control NAME_CONTROL FROM HR_LOCATIONS per_loc, PER_ADDRESSES per_addr, PER_ALL_ASSIGNMENTS_F per_assgn, PER_ADDRESSES per_addr_prov, (SELECT distinct papf1.person_id, papf1.national_identifier FROM PER_ALL_PEOPLE_F papf1 WHERE NVL(papf1.effective_end_date,sysdate +9000) = (SELECT MAX(DECODE(papf2.effective_end_date,'',sysdate+9000,papf2.effective_end_date)) FROM PER_ALL_PEOPLE_F papf2 WHERE papf1.person_id=papf2.person_id)) papf, PO_VENDOR_SITES pvs, PO_VENDORS pv WHERE pv.employee_id = papf.person_id AND nvl(pv.vendor_type_lookup_code, 'DUMMY') = 'EMPLOYEE' AND pv.vendor_id = pvs.vendor_id AND pv.employee_id = per_addr.person_id(+) AND per_addr.primary_flag(+) = 'Y' AND SYSDATE BETWEEN per_addr.date_from(+) AND NVL(per_addr.date_to(+), SYSDATE + 1) AND pv.employee_id = per_addr_prov.person_id(+) AND nvl(per_addr_prov.address_type(+),'N') = 'M' AND SYSDATE BETWEEN per_addr_prov.date_from(+) AND NVL(per_addr_prov.date_to(+), SYSDATE + 1) AND pv.employee_id = per_assgn.person_id(+) AND per_assgn.location_id = per_loc.location_id(+) AND per_assgn.assignment_type(+) = 'E' AND per_assgn.primary_flag(+) = 'Y' AND (TRUNC(SYSDATE) BETWEEN per_assgn.effective_start_date(+) AND per_assgn.effective_end_date(+)) AND (NVL(pvs.tax_reporting_site_flag,'N') = 'Y' OR (pvs.vendor_site_code = (select min(vendor_site_code) from po_vendor_sites pvs2 where pvs2.vendor_id = pvs.vendor_id and nvl(inactive_date, sysdate + 9000) = (select max(decode(inactive_date, '', sysdate + 9000, inactive_date)) from po_vendor_sites pvs3 where pvs3.vendor_id = pvs.vendor_id)) AND not exists (SELECT 'A tax reporting site exists for this vendor' FROM po_vendor_sites pvs4 WHERE NVL(pvs4.tax_reporting_site_flag,'N') = 'Y' AND pvs4.vendor_id = pvs.vendor_id)))) pvw WHERE TD.vendor_id = pvw.vendor_id AND pvw.vendor_id IN (SELECT X.vendor_id FROM ap_1099_tape_data X GROUP BY vendor_id HAVING sum(nvl(misc1, 0)) + sum(nvl(misc3, 0)) + sum(nvl(misc6, 0)) + sum(nvl(misc7, 0)) + sum(nvl(misc9, 0)) + sum(nvl(misc10, 0)) + sum(nvl(misc11, 0))/*Bug33372456*/ >= :P_FEDERAL_REPORTING_LIMIT OR sum(nvl(misc2, 0)) >= 10 OR sum(nvl(misc8, 0)) >= 10 OR sum(nvl(misc15aT, 0)) + sum(nvl(misc15aNT, 0)) >= :P_FEDERAL_REPORTING_LIMIT OR sum(nvl(misc13, 0)) + sum(nvl(misc14, 0)) + sum(nvl(misc5, 0)) > 0 OR sum(nvl(misc15b, 0)) > 0 /*OR sum(nvl(misc4, 0)) > 0 Bug33372456 - commented*/OR sum(nvl(nec4, 0)) > 0/*Bug33372456*/ OR sum(nvl(misc7, 0)) +sum(nvl(misc15aT, 0)) +sum(nvl(misc15b, 0)) >= :P_FEDERAL_REPORTING_LIMIT /*Bug33372456*/ OR sum(nvl(misc11, 0)) >= :P_FEDERAL_REPORTING_LIMIT /*Bug33372456*/ UNION SELECT Y.vendor_id FROM ap_1099_tape_data Y WHERE region_code is not null) AND nvl(misc1, 0) + nvl(misc2, 0) + nvl(misc3, 0) + nvl(misc4, 0) + nvl(misc5, 0) + nvl(misc6, 0) + nvl(misc7, 0) + nvl(misc8, 0) + nvl(misc9, 0) + nvl(misc10, 0) + nvl(misc13, 0) + nvl(misc14, 0) + nvl(misc15aT, 0) + nvl(misc15aNT, 0) + nvl(misc15b, 0) + nvl(misc11, 0)/*Bug33372456*/ > 0 AND ft.territory_code(+) = pvw.country GROUP BY rownum, pvw.vendor_name, TD.region_code,/*Bug33372456*/ pvw.name_control, pvw.organization_type_lookup_code, nvl(pvw.national_identifier, nvl(pvw.individual_1099, pvw.num_1099)), pvw.segment1, pvw.tax_reporting_name, pvw.country, ft.territory_short_name, pvw.address_line1, pvw.address_line2, pvw.address_line3, pvw.city, pvw.province, pvw.state, pvw.zip, pvw.vendor_id) x WHERE x.n_misc7 > 0 AND to_char(:P_START_YEAR_DATE, 'YYYY')>=2020 AND :P_RETURN_TYPE = 'NEC' ORDER BY 1 SQLAP APXT7CMT2 AR AP ناشر XML للوسيط الإلكتروني 1099 Imported from BI Publisher Description: تقرير ناشر XML للوسيط الإلكتروني 1099 Application: المدفوعات Source: ناشر XML للوسيط الإلكتروني 1099 Short Name: APXT7CMT2 DB package: AP_APXT7CMT2_XMLP_PKG D AP 1099 Datenaustauschmedien - BI Publisher Imported from BI Publisher Description: 1099 Datenaustauschmedien - BI Publisher-Auswertung Application: Kreditoren Source: 1099 Datenaustauschmedien - BI Publisher Short Name: APXT7CMT2 DB package: AP_APXT7CMT2_XMLP_PKG E AP XML Publisher de1099 de Medios Electrónicos Imported from BI Publisher Description: Informe de XML Publisher de1099 de Medios Electrónicos Application: Payables Source: XML Publisher de1099 de Medios Electrónicos Short Name: APXT7CMT2 DB package: AP_APXT7CMT2_XMLP_PKG F AP Honoraires sur support magnétique - XML Publisher Imported from BI Publisher Description: Honoraires sur support magnétique - Etat XML Publisher Application: Payables Source: Honoraires sur support magnétique - XML Publisher Short Name: APXT7CMT2 DB package: AP_APXT7CMT2_XMLP_PKG I AP Supporti elettronici 1099 - XML Publisher Imported from BI Publisher Description: Supporti elettronici 1099 - Rapporto di XML Publisher Application: Payables Source: Supporti elettronici 1099 - XML Publisher Short Name: APXT7CMT2 DB package: AP_APXT7CMT2_XMLP_PKG JA AP 1099電子メディアXMLパブリッシャ Imported from BI Publisher Description: 1099電子メディアXMLパブリッシャ・レポート Application: Payables Source: 1099電子メディアXMLパブリッシャ Short Name: APXT7CMT2 DB package: AP_APXT7CMT2_XMLP_PKG KO AP 1099 전자 매체 XML Publisher Imported from BI Publisher Description: 1099 전자 매체 XML Publisher 보고서 Application: Payables Source: 1099 전자 매체 XML Publisher Short Name: APXT7CMT2 DB package: AP_APXT7CMT2_XMLP_PKG PTB AP Mídia Eletrônica 1099 do XML Publisher Imported from BI Publisher Description: Relatório de Mídia Eletrônica 1099 do XML Publisher Application: Payables Source: Mídia Eletrônica 1099 do XML Publisher Short Name: APXT7CMT2 DB package: AP_APXT7CMT2_XMLP_PKG RU AP Электронный носитель, форма 1099 (XML Publisher) Imported from BI Publisher Description: Отчет на электронном носителе, форма 1099 (XML Publisher) Application: Кредиторы Source: Электронный носитель, форма 1099 (XML Publisher) Short Name: APXT7CMT2 DB package: AP_APXT7CMT2_XMLP_PKG S AP 1099 elektroniska media - XML Publisher Imported from BI Publisher Description: 1099 elektroniska media - XML Publisher-rapport Application: Payables Source: 1099 elektroniska media - XML Publisher Short Name: APXT7CMT2 DB package: AP_APXT7CMT2_XMLP_PKG TR AP 1099 Elektronik Ortam XML Yayımcısı Imported from BI Publisher Description: 1099 Elektronik Ortam XML Yayımcı Raporu Application: Borçlar Muhasebesi Source: 1099 Elektronik Ortam XML Yayımcısı Short Name: APXT7CMT2 DB package: AP_APXT7CMT2_XMLP_PKG US AP 1099 Electronic Media XML Publisher Imported from BI Publisher Description: 1099 Electronic Media XML Publisher Report Application: Payables Source: 1099 Electronic Media XML Publisher Short Name: APXT7CMT2 DB package: AP_APXT7CMT2_XMLP_PKG ZHS AP 1099 电子介质 XML Publisher Imported from BI Publisher Description: 1099 电子介质 XML Publisher 报表 Application: 应付帐款 Source: 1099 电子介质 XML Publisher Short Name: APXT7CMT2 DB package: AP_APXT7CMT2_XMLP_PKG BI Publisher 1=1 :applications_template_report :c_address :c_amount_indicator :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_chart_of_accounts_id :c_city :c_combined_flag :c_data_exists :c_double_space :c_ein :c_error_reason :c_error_vendor :c_first_name :c_indicator_status :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_number_of_b_recs :c_payment_year :c_prior_year_data :c_record_sequence :c_record_sequence_nec :c_report_start_date :c_second_name :c_space :c_state :c_tin :c_transfer_flag :c_transmitter_address :c_transmitter_csz :c_transmitter_name :c_zip :operating_unit :p_address_choice :p_conc_request_id :p_contact_email :p_contact_name :p_debug_switch :p_electronic_file_name :p_end_year_date :p_federal_reporting_limit :p_file_indicator :p_flexdata :p_foreign_payer_yn :p_last_filing_yn :p_min_precision :p_name_control :p_original_file :p_output_type :p_query_driver :p_replacement_alpha_character :p_return_type :p_set_of_books_id :p_start_year_date :p_tax_entity_id :p_tcc :p_telephone_number :p_test_yn :p_trace_switch 1 -10 :p_set_of_books_id Char fnd_profile.value('GL_SET_OF_BKS_ID') AR دفتر الأستاذ معرف دفتر الأستاذ D Buch Buchkennung E Libro Mayor Id Libro Mayor F Livre ID livre I Libro contabile Id libro contabile JA 元帳 元帳ID KO 원장 원장 ID PTB Razão Id do Razão RU Книга Идентификатор книги S Huvudbok Huvudboks-id TR Defter Defter No US Ledger Ledger Id ZHS 分类帐 分类帐标识 2 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 3 10 :p_name_control Char AR اسم عنصر التحكم اسم عنصر التحكم D Steuerfunktion Steuerfunktion E Nombre del Control Nombre del Control F Nom de contrôle Nom de contrôle I Nome controllo Nome controllo JA 管理名 管理名 KO 관리명 관리명 PTB Nome do Controle Nome do Controle RU Имя элемента Имя элемента S Kontroll Kontroll TR Kontrol Adı Kontrol Adı US Control Name Control Name ZHS 控制名称 控制名称 4 20 :p_tcc Char Y AR رمز عنصر التحكم رمز عنصر التحكم D Steuerungsschlüssel Steuerungsschlüssel E Código de Control Código de Control F Code de contrôle Code de contrôle I Codice controllo Codice controllo JA 管理コード 管理コード KO 관리 코드 관리 코드 PTB Código de Controle Código de Controle RU Код элемента Код элемента S Kontrollkod Kontrollkod TR Kontrol Kodu Kontrol Kodu US Control Code Control Code ZHS 控制代码 控制代码 5 30 :p_start_year_date Date Y AR من تاريخ السداد من تاريخ السداد D Von Zahlungsdatum Von Zahlungsdatum E De Fecha de Pago De Fecha de Pago F Date de règlement - Du Date de règlement - Du I Data pagamento - Da Data pagamento - Da JA 支払日:自 支払日:自 KO 지급 시작 일자 지급 시작 일자 PTB Data do Pagamento - De Data do Pagamento - De RU Дата платежа с Дата платежа с S Från betalningsdatum Från betalningsdatum TR İlk Ödeme Tarihi İlk Ödeme Tarihi US From Payment Date From Payment Date ZHS 自付款日期 自付款日期 6 40 :p_end_year_date Date Y AR إلى تاريخ السداد إلى تاريخ السداد D Bis Zahlungsdatum Bis Zahlungsdatum E A Fecha de Pago A Fecha de Pago F Date de règlement - Au Date de règlement - Au I Data pagamento - A Data pagamento - A JA 支払日:至 支払日:至 KO 지급 종료 일자 지급 종료 일자 PTB Data do Pagamento - Até Data do Pagamento - Até RU Дата платежа по Дата платежа по S Till betalningsdatum Till betalningsdatum TR Son Ödeme Tarihi Son Ödeme Tarihi US To Payment Date To Payment Date ZHS 至付款日期 至付款日期 7 50 :p_tax_entity_id LOV Oracle AP_SRS_TAX_REPORTING_ENTITIES Y select tax_entity_id id, entity_name value, null description from ap_reporting_entities order by value,description select entity_name from ap_reporting_entities where 1 = (select count(*) from ap_reporting_entities) Y AR كيان تقرير الضريبة كيان تقرير الضريبة D Steuerpflichtiger Steuerpflichtiger E Entidad Fiscal Entidad Fiscal F Entité DAS2 Entité DAS2 I Soggetto fiscale Soggetto fiscale JA 税金レポート・エンティティ 税金レポート・エンティティ KO 세금 신고 법인 세금 신고 법인 PTB Entidade para Geração de Relatórios de Imposto Entidade para Geração de Relatórios de Imposto RU Единица налоговой отчетности Единица налоговой отчетности S Rapporteringsenhet Rapporteringsenhet TR Vergi Raporlama Birimi Vergi Raporlama Birimi US Tax Reporting Entity Tax Reporting Entity ZHS 纳税申报实体 纳税申报实体 8 60 :p_output_type LOV Oracle AP_SRS_1099_TAPE Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where lookup_type='1099 TAPE TYPE' order by value,description select displayed_field from ap_lookup_codes where lookup_type = '1099 TAPE TYPE' and lookup_code = 'ELECTRONIC' Y AR نوع الوسائط نوع الوسائط D Medienart Medienart E Tipo de Medio Tipo de Medio F Type de support Type de support I Tipo di supporto Tipo di supporto JA メディア・タイプ メディア・タイプ KO 매체 유형 매체 유형 PTB Tipo de Mídia Tipo de Mídia RU Тип носителя Тип носителя S Medietyp Medietyp TR Ortam Tipi Ortam Tipi US Media Type Media Type ZHS 介质类型 介质类型 9 70 :p_test_yn LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' Y AR تقديم الاختبار تقديم الاختبار D Teststart Teststart E Ejecución de Pruebas Ejecución de Pruebas F Lancer le test Lancer le test I Sottomissione test Sottomissione test JA テスト実行 テスト実行 KO 테스트 실행 테스트 실행 PTB Submissão de Teste Submissão de Teste RU Пробная отправка Пробная отправка S Testkörning Testkörning TR Test Başlatma Test Başlatma US Test Submission Test Submission ZHS 测试提交 测试提交 10 80 :p_foreign_payer_yn LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' Y AR شركة أجنبية شركة أجنبية D Ausländisches Unternehmen Ausländisches Unternehmen E Corporación Extranjera Corporación Extranjera F Société privée étrangère Société privée étrangère I Società straniera Società straniera JA 国外企業 国外企業 KO 외국 기업 외국 기업 PTB Multinacional Multinacional RU Иностранная корпорация Иностранная корпорация S Utländskt företag Utländskt företag TR Yabancı Şirket Yabancı Şirket US Foreign Corporation Foreign Corporation ZHS 外国公司 外国公司 11 90 :p_last_filing_yn LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' Y AR إعداد ملفات السنة الأخيرة إعداد ملفات السنة الأخيرة D Letztjährige Ablage Letztjährige Ablage E Declaración del Último Año Declaración del Último Año F Classement dernier exercice Classement dernier exercice I Archiviazione anno precedente Archiviazione anno precedente JA 年次最終ファイル 年次最終ファイル KO 마지막 신고 연도 마지막 신고 연도 PTB Arquivamento do Ano Anterior Arquivamento do Ano Anterior RU Прошлогодние документы Прошлогодние документы S Sista årets transaktioner Sista årets transaktioner TR Geçen Yıl Dosyalaması Geçen Yıl Dosyalaması US Last Year Filing Last Year Filing ZHS 最后年度归档 最后年度归档 12 100 :p_address_choice LOV Oracle AP_SRS_COMPANY_DERIVATION Y select alc.lookup_code id, alc.displayed_field value, decode(alc.lookup_code,'ADDRESS1',hl.address_line_1,'LOCATION',hl.location_code,'REP_ENTITY',are.entity_name) description from ap_lookup_codes alc,ap_reporting_entities are,hr_locations hl where alc.lookup_type='COMPANY DERIVATION' and are.location_id=hl.location_id and are.tax_entity_id= :$flex$.ap_srs_tax_reporting_entities order by value,description AR مصدر اسم الدافع مصدر اسم الدافع D Herkunft Rechnungsempfänger Herkunft Rechnungsempfänger E Origen del Nombre del Comprador Origen del Nombre del Comprador F Origine du nom du payeur Origine du nom du payeur I Origine nome contribuente Origine nome contribuente JA 支払人名ソース 支払人名ソース KO 지급자명 출처 지급자명 출처 PTB Origem do Nome do Pagador Origem do Nome do Pagador RU Источник имени плательщика Источник имени плательщика S Betalare, källa Betalare, källa TR Ödeyen Adı Kaynağı Ödeyen Adı Kaynağı US Payer Name Source Payer Name Source ZHS 付款人名称来源 付款人名称来源 13 110 :p_query_driver Char PAY AR مشغل الاستعلام مشغل الاستعلام D Abfrage-Treiber Abfrage-Treiber E Controlador de Consultas Controlador de Consultas F Paramètre de détermination de compte (query driver) Paramètre de détermination de compte (query driver) I Esegui query su driver Esegui query su driver JA クエリー・ドライバ クエリー・ドライバ KO 질의 드라이버 질의 드라이버 PTB Driver de Consulta Driver de Consulta RU Драйвер запроса Драйвер запроса S Drivrutin för sökning Drivrutin för sökning TR Sorgulama Sürücüsü Sorgulama Sürücüsü US Query Driver Query Driver ZHS 查询驱动程序 查询驱动程序 14 120 :p_telephone_number Number Y AR رقم هاتف الممثل رقم هاتف والرقم الداخلي للممثل D Bearbeiter Telefon-Nr. Bearbeiter Telefon-Nr. und Dw. E Número de Teléfono de Contacto Número de teléfono y extensión del contacto F Numéro téléphone contact Numéro de téléphone du contact et poste I Numero telefonico contatto Numero di telefono e interno del contatto JA 担当者電話番号 担当者電話番号および内線番号 KO 담당자 전화 번호 담당자 전화 번호 및 내선 PTB Número de Telefone de Contato Número de Telefone e Ramal de Contato RU Контактный телефон Контактный телефон и добавочный номер S Kontaktpersonens telefonnr Kontaktpersonens telefonnummer och anknytning TR İlgili Kişi Telefon Numarası İlgili Kişi Telefon Numarası ve Dahili Numarası US Contact Telephone Number Contact Telephone Number and Extension ZHS 联系人电话号码 联系人电话号码和分机 15 130 :p_contact_name Char Y AR اسم الممثل اسم الممثل D Bearbeitername Bearbeitername E Nombre del Contacto Nombre del Contacto F Nom du contact Nom du contact I Nome contatto Nome contatto JA 担当名 担当名 KO 담당자명 담당자명 PTB Nome de Contato Nome de Contato RU Контактное лицо Контактное лицо S Kontaktperson Kontaktperson TR İlgili Kişi Adı İlgili Kişi Adı US Contact Name Contact Name ZHS 联系人姓名 联系人姓名 16 140 :p_contact_email Char AR البريد الإلكتروني للممثل البريد الإلكتروني للممثل D Bearbeiter E-Mail-Adresse Bearbeiter E-Mail-Adresse E Correo Electrónico del Contacto Correo Electrónico del Contacto F Email du contact Email du contact I E-mail contatto E-mail contatto JA 担当者Eメール 担当者Eメール KO 담당자 전자메일 담당자 전자메일 PTB E-mail de Contato E-mail de Contato RU Адрес электронной почты контакта Адрес электронной почты контакта S Kontaktpersonens e-postadress Kontaktpersonens e-postadress TR İlgili Kişi E-Postası İlgili Kişi E-Postası US Contact E-mail Contact E-mail ZHS 联系人电子邮件 联系人电子邮件 17 150 :p_file_indicator LOV Oracle AP_1099_FILE_INDICATOR Y select lookup_code id, displayed_field value, description description from ap_lookup_codes where lookup_type='AP_1099_FILE_TYPE' and nvl(inactive_date,sysdate+1)>sysdate order by displayed_field O Y AR مؤشر الملف مؤشر الملف D Datei-Indikator Datei-Indikator E Fichero Fichero F Indicateur de fichier Indicateur de fichier I Identificatore file Identificatore file JA ファイル識別子 ファイル識別子 KO 파일 지시자 파일 지시자 PTB Indicador de Arquivo Indicador de Arquivo RU Индикатор файла Индикатор файла S Filindikator Filindikator TR Dosya Göstergesi Dosya Göstergesi US File Indicator File Indicator ZHS 文件指示符 文件指示符 18 160 :p_original_file LOV Oracle AP_1099_ORIGINAL_FILE Y select lookup_code id, displayed_field value, description description from ap_lookup_codes where lookup_type='1099 ORIGINAL FILE' and (:$flex$.ap_1099_file_indicator='R' and lookup_code in ('M','E')) or (:$flex$.ap_1099_file_indicator in ('C','O') and lookup_code='N/A') order by value,description Y AR الملف الأصلي الملف الأصلي D Originaldatei Originaldatei E Fichero Original Fichero Original F Fichier d'origine Fichier d'origine I File originale File originale JA 当初ファイル 当初ファイル KO 최초 파일 최초 파일 PTB Arquivo Original Arquivo Original RU Исходный файл Исходный файл S Originalfil Originalfil TR İlk Dosya İlk Dosya US Original File Original File ZHS 原始文件 原始文件 19 170 :p_replacement_alpha_character Char AR إبدال حرف أبجدي إبدال حرف أبجدي D Alphabetisches Ersetzungszeichen Alphabetisches Ersetzungszeichen E Carácter Alfanumérico de Sustitución Carácter Alfanumérico de Sustitución F Caractère alpha de remplacement Caractère alpha de remplacement I Carattere alfabetico di sostituzione Carattere alfabetico di sostituzione JA 置換アルファベット文字 置換アルファベット文字 KO 대체 알파 문자 대체 알파 문자 PTB Caractere Alfa de Substituição Caractere Alfa de Substituição RU Буква замены Буква замены S Ersättning, alfatecken Ersättning, alfatecken TR Değiştirme Alfa Karakteri Değiştirme Alfa Karakteri US Replacement Alpha Character Replacement Alpha Character ZHS 替换字母字符 替换字母字符 20 180 :p_electronic_file_name Char AR اسم الملف الإلكتروني اسم الملف الإلكتروني D Elektronische Datei Elektronische Datei E Nombre de Fichero Electrónico Nombre de Fichero Electrónico F Nom du fichier électronique Nom du fichier électronique I Nome file elettronico Nome file elettronico JA 電子ファイル名 電子ファイル名 KO 전자 파일명 전자 파일명 PTB Nome do Arquivo Eletrônico Nome do Arquivo Eletrônico RU Имя электронного файла Имя электронного файла S Elektronisk fil Elektronisk fil TR Elektronik Dosya Adı Elektronik Dosya Adı US Electronic File Name Electronic File Name ZHS 电子文件名 电子文件名 21 190 :p_federal_reporting_limit Number 600 Y AR حد التقرير الفيدرالي حد التقرير الفيدرالي D Limit Erklärung an US-Finanzamt Limit Erklärung an US-Finanzamt E Límite de Declaración a Hacienda Límite de Declaración a Hacienda F Limite de déclaration fédérale Limite de déclaration fédérale I Limite dichiarazione federale Limite dichiarazione federale JA 連邦レポート制限 連邦レポート制限 KO 연방 보고 한도 연방 보고 한도 PTB Limite do Relatório Federal Limite do Relatório Federal RU Федеральный предел отчетности Федеральный предел отчетности S Gräns för federal rapportering Gräns för federal rapportering TR Federal Raporlama Limiti Federal Raporlama Limiti US Federal Reporting Limit Federal Reporting Limit ZHS 联邦申报限制 联邦申报限制 22 200 :p_return_type LOV Oracle Return Type Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1029821 order by ffvv.flex_value MISC Y AR نوع المرتجع نوع المرتجع D Rückgabeart Rückgabeart E Tipo de Devolución Tipo de Devolución F Type de retour Type de retour I Tipo di restituzione Tipo di restituzione JA 戻りタイプ 戻りタイプ KO 반환 유형 반환 유형 PTB Tipo de Devolução Tipo de Devolução RU Тип возврата Тип возврата S Returtyp Returtyp TR İade Tipi İade Tipi US Return Type Return Type ZHS 返回类型 返回类型