ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0393869E053B46B63588994 SELECT aprea.ENTITY_NAME CONTRACTOR_NAME, aprea.TAX_OFFICE_NUMBER, aprea.PAYE_REFERENCE, -- rownum RECORD_NUM, hrl.address_line_1 ADDRESS_LINE_1, hrl.address_line_2 ADDRESS_LINE_2, hrl.address_line_3 ADDRESS_LINE_3, hrl.POSTAL_CODE CONTRACTOR_POSTAL_CODE, hrl.REGION_1 CONTRACTOR_REGION_1, hrl.REGION_2 CONTRACTOR_REGION_2, hrl.REGION_3 CONTRACTOR_REGION_3, hrl.TELEPHONE_NUMBER_1 CONTRACTOR_TELEPHONE_NUMBER_1, hrl.TELEPHONE_NUMBER_2 CONTRACTOR_TELEPHONE_NUMBER_2, hrl.TELEPHONE_NUMBER_3 CONTRACTOR_TELEPHONE_NUMBER_3, hrl.TOWN_OR_CITY CONTRACTOR_TOWN_OR_CITY, hrl.COUNTRY CONTRACTOR_COUNTRY_SHORT_NAME, hrl.LOCATION_CODE CONTRACTOR_LOCATION_CODE, hrl.DESCRIPTION CONTRACTOR_DESCRIPTION, hrl.TAX_NAME CONTRACTOR_TAX_NAME, hdr.UNIQUE_TAX_REFERENCE_NUM CONTRACTOR_UTR, lines.vendor_name SUBCONTRACTOR_NAME, -- lag(lines.vendor_name,1) over (order by lines.vendor_name ) PREVIOUS_SUBCONT_NAME, lines.SALUTATION SALUTATION, lines.FIRST_NAME FIRST_NAME, lines.LAST_NAME LAST_NAME, lines.trading_name TRADING_NAME, pvs.address_line1 SUB_ADDRESS_LINE1, pvs.address_line2 SUB_ADDRESS_LINE2, pvs.address_line3 SUB_ADDRESS_LINE3, pvs.city CITY, pvs.state STATE, pvs.country COUNTRY, pvs.ZIP SUB_ZIP, pvs.PROVINCE SUB_PROVINCE, pvs.AREA_CODE SUB_AREA_CODE, pvs.PHONE SUB_PHONE, pvs.FAX SUB_FAX, pvs.FAX_AREA_CODE SUB_FAX_AREA_CODE, pvs.TELEX SUB_TELEX, pvs.ADDRESS_LINE4 SUB_ADDRESS_LINE4, pvs.COUNTY SUB_COUNTY, pvs.EMAIL_ADDRESS SUB_EMAIL_ADDRESS, lines.VERIFICATION_NUMBER VERIFICATION_NUMBER, lines.UNIQUE_TAX_REFERENCE_NUM SUBCONTRACTOR_UTR &P_SELECT_CLAUSE FROM igi_cis_mth_ret_hdr_h hdr, igi_cis_mth_ret_lines_h lines, ap_reporting_entities aprea, ap_supplier_sites pvs &P_FROM_CLAUSE WHERE hdr.HEADER_ID = lines.HEADER_ID AND hdr.REQUEST_STATUS_CODE = 'C' AND aprea.unique_tax_reference_num = hdr.unique_tax_reference_num AND pvs.vendor_id = lines.vendor_id AND ((pvs.PRIMARY_PAY_SITE_FLAG = 'Y' AND NVL(pvs.INACTIVE_DATE,sysdate) >= sysdate) OR pvs.VENDOR_SITE_ID = (select min(site.VENDOR_SITE_ID) from AP_SUPPLIER_SITES site where pvs.VENDOR_ID = site.VENDOR_ID and NVL(site.INACTIVE_DATE,sysdate) >= sysdate AND site.PAY_SITE_FLAG = 'Y' and NOT EXISTS(select 1 from AP_SUPPLIER_SITES vsite where vsite.VENDOR_ID = site.VENDOR_ID and vsite.PRIMARY_PAY_SITE_FLAG = 'Y' and NVL(vsite.INACTIVE_DATE,sysdate) >= sysdate ))) &P_WHERE_CLAUSE Y IGI IGIPPADR_XMLP AR IGI تقرير كشف حساب المتعاقدين من الباطن للسداد والاستقطاعات في CIS2007 Application: الماليات الدولية للقطاع العام Source: IGI : تقرير كشف حساب المتعاقدين من الباطن للسداد والاستقطاعات في CIS2007 Short Name: IGIPPADR_XMLP DB package: IGI_CIS2007_IGIPPADR_PKG D IGI CIS2007 Subunternehmer - Steuerzahlungs- und Abzugsaufstellung Application: Public Sector Financials International Source: IGI: CIS2007 Subunternehmer - Steuerzahlungs- und Abzugsaufstellung Short Name: IGIPPADR_XMLP DB package: IGI_CIS2007_IGIPPADR_PKG F IGI CIS2007 - Etat des déclarations sous-traitant des règlements et des déductions Application: Public Sector Financials International Source: IGI : CIS2007 - Etat des déclarations sous-traitant des règlements et des déductions Short Name: IGIPPADR_XMLP DB package: IGI_CIS2007_IGIPPADR_PKG US IGI CIS2007 Subcontractor Statement of Payment and Deductions Application: Public Sector Financials International Source: IGI : CIS2007 Subcontractor Statement of Payment and Deductions Report Short Name: IGIPPADR_XMLP DB package: IGI_CIS2007_IGIPPADR_PKG ZHS IGI IGI：CIS2007 分包商付款报表和扣除额报表 Application: Public Sector Financials International Source: IGI：CIS2007 分包商付款报表和扣除额报表 Short Name: IGIPPADR_XMLP DB package: IGI_CIS2007_IGIPPADR_PKG BI Publisher &p_from_clause &p_select_clause &p_where_clause :operating_unit :p_from_clause :p_period :p_print_type :p_select_clause :p_supplier_from :p_supplier_to :p_total_type :p_where_clause :p_zero_deductions 1 10 :p_period LOV Oracle IGI_CIS2007_PERIODS Y select period_name id, period_name value, null description from ap_other_periods where period_type=fnd_profile.value('IGI_CIS2007_CALENDAR') order by period_year desc,period_num desc Y AR الفترة D Periode F Période US Period ZHS 期间 2 20 :p_supplier_from LOV Oracle IGI_CIS2007_MTH_SUPPLIERS Y select vendor_name id, vendor_name value, null description from ap_suppliers where vendor_id in (select chld.vendor_id from ap_suppliers prnt,ap_suppliers chld where prnt.vendor_id(+)=chld.cis_parent_vendor_id and (prnt.cis_enabled_flag='Y' or chld.cis_enabled_flag='Y')) order by vendor_name AR مورد من D Von Lieferant F Fournisseur - De US Supplier From ZHS 供应商自 3 30 :p_supplier_to LOV Oracle IGI_CIS2007_MTH_SUPPLIERS Y select vendor_name id, vendor_name value, null description from ap_suppliers where vendor_id in (select chld.vendor_id from ap_suppliers prnt,ap_suppliers chld where prnt.vendor_id(+)=chld.cis_parent_vendor_id and (prnt.cis_enabled_flag='Y' or chld.cis_enabled_flag='Y')) order by vendor_name AR مورد إلى D Bis Lieferant F Fournisseur - A US Supplier To ZHS 供应商至 4 40 :p_total_type LOV Oracle IGI_CIS2007_TOTAL_TYPE Y select lookup_code id, meaning value, null description from igi_lookups where lookup_type='IGI_CIS2007_TOTAL_TYPE' order by meaning Y AR الإجمالي/لكل سداد D Summe/Pro Zahlung F Total/Par règlement US Total/Per Payment ZHS 合计/平均计算付款 5 50 :p_print_type LOV Oracle IGI_CIS2007_PRINT_TYPES Y select lookup_code id, meaning value, null description from igi_lookups where lookup_type='IGI_CIS2007_PRINT_TYPES' order by meaning Y AR أصلي/متكرر D Original/Duplikat F Initial/Doublon US Original/Duplicate ZHS 原始/副本 6 60 :p_zero_deductions LOV Oracle IGI_CIS2007_YES_NO Y select lookup_code id, meaning value, null description from igi_lookups where lookup_type='IGI_CIS2007_YES_NO' order by meaning Select meaning from IGI_LOOKUPS where lookup_type = 'IGI_CIS2007_YES_NO' and lookup_code = 'N' Y AR طباعة الاستقطاعات المعفية من الضرائب D Steuerabzüge von Null drucken F Imprimer les déductions fiscales à zéro US Print Zero Tax Deductions ZHS 打印零税扣除额