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）限制的操作单元。 C6E085D471AF51A9E05362FB09050512 select csh.schedule_id, csh.schedule_num, csh.schedule_type , polc1.displayed_field Type, polc2.displayed_field Status, csh.schedule_horizon_start Horizon_Start, csh.schedule_horizon_end Horizon_End, cbp.bucket_pattern_name Bucket, csh.schedule_revision Rev, csh.mrp_compile_designator MRP_Plan, csh.mps_schedule_designator MSP_Plan, csh.drp_compile_designator DRP_Plan, pov.vendor_name Supplier, povs.vendor_site_code Site, povs.address_line1 A1ddress, povs.address_line2 A2ddress, povs.address_line3 A3ddress, povs.city||', '|| povs.state||' '|| povs.zip A4ddress from chv_schedule_headers csh, chv_bucket_patterns cbp, po_vendors pov, po_vendor_sites povs, po_lookup_codes polc1, po_lookup_codes polc2 where csh.bucket_pattern_id = cbp.bucket_pattern_id and csh.vendor_id = pov.vendor_id and csh.vendor_site_id = povs.vendor_site_id and csh.schedule_subtype = polc1.lookup_code and polc1.lookup_type = decode(csh.schedule_type, 'PLAN_SCHEDULE','PLAN_SCHEDULE_SUBTYPE', 'SHIP_SCHEDULE_SUBTYPE') and csh.schedule_status = polc2.lookup_code and polc2.lookup_type = 'SCHEDULE_STATUS' and nvl(:P_schedule_sub, polc1.displayed_field) = polc1.displayed_field and nvl(:P_schedule_type, csh.schedule_type) = csh.schedule_type and pov.vendor_name between nvl(:P_vendor_name_from, pov.vendor_name) and nvl(:P_vendor_name_to,pov.vendor_name) and nvl(:P_site, povs.vendor_site_code) = povs.vendor_site_code and nvl(:P_schedule_num, csh.schedule_num) = csh.schedule_num and nvl(:P_schedule_rev, csh.schedule_revision) = csh.schedule_revision and nvl(:P_horizon_start, csh.schedule_horizon_start) between csh.schedule_horizon_start and csh.schedule_horizon_end and nvl(:P_horizon_end, csh.schedule_horizon_end) between csh.schedule_horizon_start and csh.schedule_horizon_end and (nvl(:P_test_print, 'N') = 'Y' OR (nvl(:P_test_print, 'N') = 'N' and csh.schedule_status = 'CONFIRMED')) and nvl(:P_autoschedule_flag, 'N') = 'N' and (exists (select 1 from chv_item_orders cio where cio.schedule_id = csh.schedule_id) or nvl(:P_EXCLUDE_ZERO_QUANTITY_LINES, 'N') = 'N') union select csh.schedule_id, csh.schedule_num, csh.schedule_type , polc1.displayed_field Type, polc2.displayed_field Status, csh.schedule_horizon_start Horizon_Start, csh.schedule_horizon_end Horizon_End, cbp.bucket_pattern_name Bucket, csh.schedule_revision Rev, csh.mrp_compile_designator MRP_Plan, csh.mps_schedule_designator MSP_Plan, csh.drp_compile_designator DRP_Plan, pov.vendor_name Supplier, povs.vendor_site_code Site, povs.address_line1 A1ddress, povs.address_line2 A2ddress, povs.address_line3 A3ddress, povs.city||', '|| povs.state||' '|| povs.zip A4ddress from chv_schedule_headers csh, chv_bucket_patterns cbp, po_vendors pov, po_vendor_sites povs, po_lookup_codes polc1, po_lookup_codes polc2 where csh.bucket_pattern_id = cbp.bucket_pattern_id and csh.vendor_id = pov.vendor_id and csh.vendor_site_id = povs.vendor_site_id and csh.schedule_subtype = polc1.lookup_code and polc1.lookup_type = decode(csh.schedule_type, 'PLAN_SCHEDULE','PLAN_SCHEDULE_SUBTYPE', 'SHIP_SCHEDULE_SUBTYPE') and csh.schedule_status = polc2.lookup_code and polc2.lookup_type = 'SCHEDULE_STATUS' and (nvl(:P_test_print, 'N') = 'Y' OR (nvl(:P_test_print, 'N') = 'N' and csh.schedule_status = 'CONFIRMED')) and :P_autoschedule_flag = 'Y' and :P_batch_id = csh.batch_id and (exists ( select 1 from chv_item_orders cio where cio.schedule_id = csh.schedule_id) or nvl(:P_EXCLUDE_ZERO_QUANTITY_LINES, 'N') = 'N') order by schedule_num Y PO CHVPRSCH_XML AR PO جدول التخطيط المطبوع (بتنسيق XML) Imported from BI Publisher Description: تقرير جدول تخطيط مطبوع Application: المشتريات Source: جدول التخطيط المطبوع (بتنسيق XML) Short Name: CHVPRSCH_XML DB package: PO_CHVPRSCH_XMLP_PKG D PO Lieferpläne - gedruckt Imported from BI Publisher Description: Lieferpläne - gedruckt Application: Einkauf Source: Lieferpläne - gedruckt (XML) Short Name: CHVPRSCH_XML DB package: PO_CHVPRSCH_XMLP_PKG E PO Programa de Planificación Impreso Imported from BI Publisher Description: Informe Programa de Planificación Impreso Application: Purchasing Source: Programa de Planificación Impreso (XML) Short Name: CHVPRSCH_XML DB package: PO_CHVPRSCH_XMLP_PKG F PO Etat imprimé Programme de planification Imported from BI Publisher Description: Etat imprimé Programme de planification Application: Purchasing Source: Etat imprimé Programme de planification (XML) Short Name: CHVPRSCH_XML DB package: PO_CHVPRSCH_XMLP_PKG I PO Programma di pianificazione stampato Imported from BI Publisher Description: Rapporto Programma di pianificazione stampato Application: Purchasing Source: Programma di pianificazione stampato (XML) Short Name: CHVPRSCH_XML DB package: PO_CHVPRSCH_XMLP_PKG JA PO 印刷済計画スケジュール Imported from BI Publisher Description: 印刷済計画スケジュール・レポート Application: Purchasing Source: 印刷済計画スケジュール(XML) Short Name: CHVPRSCH_XML DB package: PO_CHVPRSCH_XMLP_PKG KO PO 인쇄된 계획 스케줄 Imported from BI Publisher Description: 인쇄된 계획 스케줄 보고서 Application: Purchasing Source: 인쇄된 계획 스케줄(XML) Short Name: CHVPRSCH_XML DB package: PO_CHVPRSCH_XMLP_PKG PTB PO Programação de Planejamento Impresso Imported from BI Publisher Description: Relatório de Programação de Planejamento Impresso Application: Compra Source: Programação de Planejamento Impresso (XML) Short Name: CHVPRSCH_XML DB package: PO_CHVPRSCH_XMLP_PKG RU PO Печатный график планирования Imported from BI Publisher Description: Отчет о печати графика планирования Application: Закупки Source: Печатный график планирования (XML) Short Name: CHVPRSCH_XML DB package: PO_CHVPRSCH_XMLP_PKG S PO Utskrift av planeringsplan Imported from BI Publisher Description: Utskrift av planeringsplan Application: Purchasing Source: Utskrift av planeringsplan (XML) Short Name: CHVPRSCH_XML DB package: PO_CHVPRSCH_XMLP_PKG TR PO Yazdırılmış Planlama Çizelgesi Imported from BI Publisher Description: Yazdırılmış Planlama Çizelgesi Raporu Application: Satın Alma Yönetimi Source: Yazdırılmış Planlama Çizelgesi (XML) Short Name: CHVPRSCH_XML DB package: PO_CHVPRSCH_XMLP_PKG US PO Printed Planning Schedule Imported from BI Publisher Description: Printed Planning Schedule Report Application: Purchasing Source: Printed Planning Schedule (XML) Short Name: CHVPRSCH_XML DB package: PO_CHVPRSCH_XMLP_PKG ZHS PO 打印计划进度表 Imported from BI Publisher Description: 打印计划进度表报表 Application: 采购管理系统 Source: 打印计划进度表 (XML) Short Name: CHVPRSCH_XML DB package: PO_CHVPRSCH_XMLP_PKG BI Publisher :operating_unit :p_autoschedule_flag :p_batch_id :p_conc_request_id :p_exclude_zero_quantity_lines :p_horizon_end :p_horizon_start :p_organization_id :p_organization_name :p_qty_precision :p_schedule_num :p_schedule_rev :p_schedule_sub :p_schedule_type :p_site :p_test_print :p_vendor_name_from :p_vendor_name_to 1 -40 :p_schedule_type Char PLAN_SCHEDULE AR نوع الجدول نوع الجدول D Planart Planart E Tipo de Programa Tipo de Programa F Type de programme Type de programme I Tipo di programma Tipo di programma JA スケジュール・タイプ スケジュール・タイプ KO 스케줄 유형 스케줄 유형 PTB Tipo de Programação Tipo de Programação RU Тип графика Тип графика S Planeringstyp Planeringstyp TR Çizelge Tipi Çizelge Tipi US Schedule Type Schedule Type ZHS 计划类型 计划类型 2 -30 :p_organization_id Number fnd_profile.value('MFG_ORGANIZATION_ID') US P_ORGANIZATION_ID Organization_id 3 -20 :p_autoschedule_flag LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE ='YES_NO' AND LOOKUP_CODE ='N' AR p_autoschedule_flag علامة الجدولة الآلية D p_autoschedule_flag Kennzeichen Automatische Planung E p_autoschedule_flag Programación Automática F p_autoschedule_flag Indicateur Planification automatique I p_autoschedule_flag Flag Programmazione automatica JA p_autoschedule_flag 自動スケジュール・フラグ KO p_autoschedule_flag 자동스케줄 플래그 PTB p_autoschedule_flag Indicador de Programação Automática RU p_autoschedule_flag Флаг автопланирования S p_autoschedule_flag Autoplan TR p_autoschedule_flag Otomatik Çizelgeleme İşareti US p_autoschedule_flag AutoSchedule Flag ZHS p_autoschedule_flag 自动计划标志 4 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 5 10 :p_schedule_num LOV Oracle CHV_SRS_SCHEDULE_NUM_PLAN Y select schedule_id id, schedule_num value, null description from chv_schedule_headers_all_v where schedule_type='PLAN_SCHEDULE' order by schedule_num AR رقم الجدول رقم الجدول D Plannummer Plannummer E Número de Programa Número de Programa F Numéro de programme Numéro de programme I Numero programma Numero programma JA スケジュール番号 スケジュール番号 KO 스케줄 번호 스케줄 번호 PTB Nº da Programação Nº da Programação RU N графика N графика S Schemanummer Schemanummer TR Çizelge Numarası Çizelge Numarası US Schedule Number Schedule Number ZHS 计划编号 计划编号 6 20 :p_schedule_rev LOV Oracle CHV_SRS_SCHEDULE_REV_PLAN Y select schedule_revision id, schedule_revision value, null description from chv_schedule_headers where schedule_id=:$flex$.chv_srs_schedule_num_plan order by chv_schedule_headers.schedule_revision AR مراجعة الجدول مراجعة الجدول D Planversion Planversion E Revisión del Programa Revisión del Programa F Version de programme Version de programme I Revisione programma Revisione programma JA スケジュール改訂 スケジュール改訂 KO 스케줄 개정 스케줄 개정 PTB Revisão da Programação Revisão da Programação RU Версия графика Версия графика S Planrevision Planrevision TR Çizelge Revizyonu Çizelge Revizyonu US Schedule Revison Schedule Revison ZHS 计划版本 计划版本 7 30 :p_schedule_sub LOV Oracle CHV_SRS_PLAN_SCHEDULE_SUBTYPE Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='PLAN_SCHEDULE_SUBTYPE' order by displayed_field AR نوع فرعي لجدول نوع فرعي لجدول D Plan-Unterart Plan-Unterart E Subtipo de Programa Subtipo de Programa F Sous-type de programme Sous-type de programme I Tipo secondario di programma Tipo secondario di programma JA スケジュール サブタイプ スケジュール サブタイプ KO 스케줄 하위유형 스케줄 하위유형 PTB Subtipo de Programação Subtipo de Programação RU Подтип графика Подтип графика S Planeringsdeltyp Planeringsdeltyp TR Çizelge Alttipi Çizelge Alttipi US Schedule Subtype Schedule Subtype ZHS 计划子类型 计划子类型 8 40 :p_horizon_start Date AR بداية النطاق بداية النطاق D Von Horizont Von Horizont E Inicio de Horizonte Inicio de Horizonte F Début d'horizon Début d'horizon I Inizio orizzonte Inizio orizzonte JA 範囲開始 範囲開始 KO 계획 대상 기간 시작 계획 대상 기간 시작 PTB Início Horizonte Início Horizonte RU Начало горизонта Начало горизонта S Horisontstart Horisontstart TR Dönem Başlangıcı Dönem Başlangıcı US Horizon Start Horizon Start ZHS 展望期起始 展望期起始 9 50 :p_horizon_end Date AR نهاية النطاق نهاية النطاق D Bis Horizont Bis Horizont E Fin de Horizonte Fin de Horizonte F Fin d'horizon Fin d'horizon I Fine orizzonte Fine orizzonte JA 範囲終了 範囲終了 KO 계획 대상 기간 종료 계획 대상 기간 종료 PTB Fim do Horizonte Fim do Horizonte RU Конец горизонта Конец горизонта S Horisontslut Horisontslut TR Dönem Sonu Dönem Sonu US Horizon End Horizon End ZHS 展望期终止日期 展望期终止日期 10 60 :p_vendor_name_from LOV Oracle PO_SRS_VENDOR_NAME Y Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name AR مورد من مورد من D Von Lieferant Von Lieferant E De Proveedor De Proveedor F Fournisseur - De Fournisseur - De I Fornitore - Da Fornitore - Da JA 仕入先:自 仕入先:自 KO 공급자: 부터 공급자: 부터 PTB Fornecedor - De Fornecedor - De RU Поставщик с Поставщик с S Från leverantör Från leverantör TR İlk Tedarikçi İlk Tedarikçi US Supplier From Supplier From ZHS 起始供应商 起始供应商 11 70 :p_vendor_name_to LOV Oracle PO_SRS_VENDOR_NAME Y Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name AR مورد إلى مورد إلى D Bis Lieferant Bis Lieferant E A Proveedor A Proveedor F Fournisseur - A Fournisseur - A I Fornitore - A Fornitore - A JA 仕入先:至 仕入先:至 KO 공급자: 까지 공급자: 까지 PTB Fornecedor - Até Fornecedor - Até RU Поставщик по Поставщик по S Till leverantör Till leverantör TR Son Tedarikçi Son Tedarikçi US Supplier To Supplier To ZHS 供应商至 供应商至 12 80 :p_site LOV Oracle PO_SRS_VENDOR_SITE Y select vendor_site_code id, vendor_site_code value, null description from po_vendor_sites order by vendor_site_code AR موقع المورِّد موقع المورِّد D Lieferantenadresse Lieferantenadresse E Sitio de Proveedor Sitio de Proveedor F Site fournisseur Site fournisseur I Sede fornitore Sede fornitore JA 仕入先サイト 仕入先サイト KO 공급자 지점 공급자 지점 PTB Local do Fornecedor Local do Fornecedor RU Отделение поставщика Отделение поставщика S Leverantörsplats Leverantörsplats TR Tedarikçi İşletme Birimi Tedarikçi İşletme Birimi US Supplier Site Supplier Site ZHS 供应商地点 供应商地点 13 90 :p_test_print LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description AR اختبار طباعة اختبار طباعة D Testseite Testseite E Impresión de Prueba Impresión de Prueba F Tester l'impression Tester l'impression I Stampa di prova Stampa di prova JA テスト印刷 テスト印刷 KO 테스트 인쇄 테스트 인쇄 PTB Teste de Impressão Teste de Impressão RU Проба печати Проба печати S Testutskrift Testutskrift TR Test Yazdırma Test Yazdırma US Test Print Test Print ZHS 测试打印 测试打印 14 100 :p_qty_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code fnd_profile.value('REPORT QUANTITY PRECISION') AR خيار الدقة الديناميكية دقة الكمية D Option Nachkommastellen Nachkommastellen E Opción Precisión Dinámica Precisión de Cantidad F Option précision dynamique Précision des quantités I Opzione precisione dinamica Precisione quantità JA 動的演算精度オプション 数量精度 KO 동적 소수점자리 옵션 수량 소수점 이하 자릿수 PTB Opção de Precisão Dinâmica Precisão da Quantidade RU Динамическая точность Точность количества S Alternativ för dynamisk precision Kvantitetsprecision TR Dinamik Duyarlılık Seçeneği Miktar Duyarlılığı US Dynamic Precision Option Quantity Precision ZHS 动态精确度选项 数量精确度 15 110 :p_exclude_zero_quantity_lines LOV Oracle INV_SRS_Y_N Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' and enabled_flag='Y' order by value,description AR p_exclude_zero_quantity_lines استبعاد سطور الكمية الصفرية D p_exclude_zero_quantity_lines Nullmengen-Positionen ausschließen E p_exclude_zero_quantity_lines Excluir Líneas con Cantidad Cero F p_exclude_zero_quantity_lines Exclure les lignes de quantités nulles I p_exclude_zero_quantity_lines Escludi linee con valore zero JA p_exclude_zero_quantity_lines ゼロ数量の明細を除く KO p_exclude_zero_quantity_lines 영(0) 수량 라인 제외 PTB p_exclude_zero_quantity_lines Excluir Zero das Linhas de Quantidade RU p_exclude_zero_quantity_lines Исключить строки с нулевыми количествами S p_exclude_zero_quantity_lines Exkludera nollkvantitets-rader TR p_exclude_zero_quantity_lines Sıfır Miktarlı Satırlar Hariç US p_exclude_zero_quantity_lines Exclude Zero Quantity Lines ZHS p_exclude_zero_quantity_lines 不包含零数量行 :$flex$.chv_srs_schedule_num_plan Schedule Number Schedule Revison