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）限制的操作单元。 C6E085D46FEF51A9E05362FB09050512 SELECT (select look_1.meaning from igi_lookups look_1 where look_1.lookup_type = 'IGI_CIS2007_YES_NO' and look_1.lookup_code = hdr.nil_return_flag) nil_return_flag, (select look_1.meaning from igi_lookups look_1 where look_1.lookup_type = 'IGI_CIS2007_YES_NO' and look_1.lookup_code = hdr.Employment_status_flag) Employment_status_flag, (select look_1.meaning from igi_lookups look_1 where look_1.lookup_type = 'IGI_CIS2007_YES_NO' and look_1.lookup_code = hdr.subcont_verify_flag) subcont_verify_flag, (select look_1.meaning from igi_lookups look_1 where look_1.lookup_type = 'IGI_CIS2007_YES_NO' and look_1.lookup_code = hdr.information_correct_flag) information_correct_flag, (select look_1.meaning from igi_lookups look_1 where look_1.lookup_type = 'IGI_CIS2007_YES_NO' and look_1.lookup_code = hdr.inactivity_indicator) inactivity_indicator, lines.vendor_name, lines.trading_name, lines.unique_tax_reference_num, lines.national_insurance_number, lines.company_registration_number, lines.verification_number, lines.vendor_id, decode(nvl(lines.VERSION_NUM,1),1, ( Select igi_cis_igipmthp_pkg.get_tax_status(to_char(IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(lines.vendor_id,null,null,null) )) from dual),lines.TAX_TREATMENT_STATUS) tax_status, &partselect sum((nvl(pay.amount,0) + nvl(pay.total_deductions,0))) total_payments, sum(nvl(pay.material_cost,0)) material_cost, sum(nvl(pay.labour_cost,0)) labour_cost, sum(nvl(pay.total_deductions,0)) total_deductions, sum(nvl(pay.total_deductions,0)) cis_tax /* COMMENTED BY VJ as CIS_TAX being used on RTF for deductions. sum(nvl(pay.cis_tax,0)) cis_tax */ FROM &tableclause WHERE lines.header_id = hdr.header_id AND pay.vendor_id(+) = lines.vendor_id AND pay.header_id(+) = lines.header_id &pwhereclause group by hdr.nil_return_flag, hdr.Employment_status_flag, hdr.subcont_verify_flag, hdr.information_correct_flag, hdr.inactivity_indicator, lines.vendor_name, lines.trading_name, lines.vendor_id, lines.unique_tax_reference_num, lines.national_insurance_number, lines.company_registration_number, lines.verification_number, nvl(lines.VERSION_NUM,1), lines.TAX_TREATMENT_STATUS &partgroupby &orderbyclause Y IGI IGIPMTHR_XMLP AR IGI تقرير الإقرارات الشهرية CIS2007 Imported from BI Publisher Description: مخطط صناعة الإنشاءات : تقرير الإقرارات الشهرية Application: الماليات الدولية للقطاع العام Source: IGI : تقرير الإقرارات الشهرية CIS2007 Short Name: IGIPMTHR_XMLP DB package: igi_cis_igipmthp_pkg D IGI CIS2007 Monatliche Steuererklärungen Imported from BI Publisher Description: Steuereinbehalt im Baugewerbe: Auswertung "Monatliche Steuererklärungen" Application: Public Sector Financials International Source: IGI: CIS2007 Monatliche Steuererklärungen Short Name: IGIPMTHR_XMLP DB package: igi_cis_igipmthp_pkg E IGI CIS2007 Declaración de Impuestos Mensual Imported from BI Publisher Description: Construction Industry Scheme: Informe de declaración de impuestos mensual Application: Public Sector Financials International Source: IGI : CIS2007 Declaración de Impuestos Mensual Short Name: IGIPMTHR_XMLP DB package: igi_cis_igipmthp_pkg F IGI CIS2007 - Etat des déclarations mensuelles Imported from BI Publisher Description: Construction Industry Scheme (régime applicable à l'industrie du bâtiment) : Etat des déclarations mensuelles Application: Public Sector Financials International Source: IGI : CIS2007 - Etat des déclarations mensuelles Short Name: IGIPMTHR_XMLP DB package: igi_cis_igipmthp_pkg I IGI rapporto utili mensili schema industria edilizia 2007 Imported from BI Publisher Description: Schema industria edilizia: rapporto utili mensili Application: Public Sector Financials International Source: IGI : rapporto utili mensili schema industria edilizia 2007 Short Name: IGIPMTHR_XMLP DB package: igi_cis_igipmthp_pkg KO IGI CIS2007 월별 환급 보고서 Imported from BI Publisher Description: 건설업 체계: 월별 환급 보고서 Application: Public Sector Financials International Source: IGI: CIS2007 월별 환급 보고서 Short Name: IGIPMTHR_XMLP DB package: igi_cis_igipmthp_pkg RU IGI CIS2007 - отчет о ежемесячной декларации Imported from BI Publisher Description: Схема для строительства: отчет о ежемесячной декларации Application: Государственный сектор: международные финансы Source: IGI: CIS2007 - отчет о ежемесячной декларации Short Name: IGIPMTHR_XMLP DB package: igi_cis_igipmthp_pkg S IGI CIS2007 - rapport över månatliga deklarationer Imported from BI Publisher Description: Byggnadsindustriplan: Rapport över månatliga deklarationer Application: Public Sector Financials International Source: IGI: CIS2007 - rapport över månatliga deklarationer Short Name: IGIPMTHR_XMLP DB package: igi_cis_igipmthp_pkg US IGI CIS2007 Monthly Returns Imported from BI Publisher Description: Construction Industry Scheme : Monthly Returns Report Application: Public Sector Financials International Source: IGI : CIS2007 Monthly Returns Report Short Name: IGIPMTHR_XMLP DB package: igi_cis_igipmthp_pkg ZHS IGI IGI：CIS2007 月报税单报表 Imported from BI Publisher Description: 建筑业模式：月报税单报表 Application: Public Sector Financials International Source: IGI：CIS2007 月报税单报表 Short Name: IGIPMTHR_XMLP DB package: igi_cis_igipmthp_pkg BI Publisher &orderbyclause &partgroupby &partselect &pwhereclause &tableclause :operating_unit :orderbyclause :p_amt_type :p_del_preview :p_mode :p_period :p_print_type :p_report_lev :p_sort_by :p_supplier_from :p_supplier_to :partgroupby :partselect :pwhereclause :tableclause 1 -20 :p_mode LOV Oracle IGI_CIS2007_MTH_RET_MODE Y select lookup_code id, meaning value, null description from igi_lookups where lookup_type='IGI_CIS2007_MTH_RET_MODE' order by meaning SELECT MEANING FROM IGI_LOOKUPS WHERE LOOKUP_TYPE = 'IGI_CIS2007_MTH_RET_MODE' AND LOOKUP_CODE = 'F' Y AR طور التقرير D Auswertungsmodus E Modo de Informe F Mode d'édition I Modalità rapporto KO 보고서 모드 RU Режим отчета S Rapportläge US Report Mode ZHS 报表模式 2 -10 :p_del_preview 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 Vorschaudatensätze löschen E Suprimir Presentación Preliminar de Registros F Supprimer les enregistrements consultés I Elimina record di anteprima KO 미리보기 레코드 삭제 RU Удал. записей предварительного просмотра S Ta bort förhandsgranskade poster US Delete Preview Records ZHS 删除预览记录 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 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 E Período F Période I Periodo KO 기간 RU Период US Period ZHS 期间 5 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 E De Proveedor F Fournisseur - De I Fornitore - Da KO 공급자 출처 RU Поставщик с S Från leverantör US Supplier From ZHS 供应商自 6 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 E A Proveedor F Fournisseur - A I Fornitore - A KO 공급자 대상 RU Поставщик по S Till leverantör US Supplier To ZHS 供应商至 7 40 :p_print_types 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 E Original/Duplicado F Initial/Doublon I Originale/Duplicato KO 원본/사본 RU Оригинал/дубликат S Original/Dubblett US Original/Duplicate ZHS 原始/副本 8 50 :p_sort_by LOV Oracle IGI_CIS2007_MTHR_SORT_COLS Y select lookup_code id, meaning value, null description from igi_lookups where lookup_type='IGI_CIS2007_MTHR_SORT_COLS' order by meaning select meaning from IGI_LOOKUPS where lookup_type = 'IGI_CIS2007_MTHR_SORT_COLS' and lookup_code = 'VENDOR_NAME' AR فرز حسب D Sortieren nach E Ordenar por F Tri par I Ordina per KO 정렬 기준 RU Сортировка S Sortera efter US Sort By ZHS 排序依据 9 60 :p_report_lev LOV Oracle IGI_CIS2007_REPORT_LEVEL Y select lookup_code id, meaning value, null description from igi_lookups where lookup_type='IGI_CIS2007_REPORT_LEVEL' order by meaning select meaning from IGI_LOOKUPS where lookup_type = 'IGI_CIS2007_REPORT_LEVEL' and lookup_code = 'S' Y AR مستوى التقرير D Auswertungsebene E Nivel de Informe F Niveau état I Livello rapporto KO 보고서 레벨 RU Уровень отчета S Rapportnivå US Report Level ZHS 报告层 10 70 :p_amt_type LOV Oracle IGI_CIS2007_MTH_RET_AMT_M Y select lookup_code id, meaning value, null description from igi_lookups where lookup_type='IGI_CIS2007_MTH_RET_AMT_TYPE' order by meaning desc AR نوع المبلغ D Betragsart E Tipo de Importe F Type de montant I Tipo importo KO 금액 유형 RU Тип суммы S Beloppstyp US Amount Type ZHS 金额类型