ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B9847D20A0E4742FE0538931640A6379 AP Supplier Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US C86F850C19E54BDDAC029167469FF31AY select ood.organization_code organization, csh.schedule_num schedule_number, decode(csh.schedule_type,'PLAN_SCHEDULE','Planning','SHIP_SCHEDULE','Shipping',csh.schedule_type) schedule_type, xxen_util.meaning(csh.schedule_subtype,decode(csh.schedule_type,'PLAN_SCHEDULE','PLAN_SCHEDULE_SUBTYPE','SHIP_SCHEDULE_SUBTYPE'),201) subtype, xxen_util.meaning(csh.schedule_status,'SCHEDULE_STATUS',201) status, csh.schedule_revision revision, cbp.bucket_pattern_name bucket_pattern, csh.schedule_horizon_start horizon_start, csh.schedule_horizon_end horizon_end, csh.mrp_compile_designator mrp_plan, csh.mps_schedule_designator mps_plan, csh.drp_compile_designator drp_plan, pov.vendor_name supplier, povs.vendor_site_code supplier_site, povs.address_line1||decode(povs.city,null,null,', '||povs.city)||decode(povs.state,null,null,', '||povs.state)||' '||povs.zip supplier_address, msibk.concatenated_segments item, msibk.description item_description, csi.purchasing_unit_of_measure uom, poh.segment1 supply_agreement, xxen_util.meaning(csi.item_planning_method,'PLANNING_METHOD',201) planning_method, (select ppf.full_name from per_all_people_f ppf where ppf.person_id=msibk.buyer_id and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date and rownum=1) buyer, (select ppf.full_name from po_asl_attributes paa, per_all_people_f ppf where paa.vendor_id=csh.vendor_id and paa.vendor_site_id=csh.vendor_site_id and paa.item_id=csi.item_id and paa.using_organization_id=(select max(paa2.using_organization_id) from po_asl_attributes paa2 where paa2.vendor_id=csh.vendor_id and paa2.vendor_site_id=csh.vendor_site_id and paa2.item_id=csi.item_id and paa2.using_organization_id in (csi.organization_id,-1)) and paa.scheduler_id=ppf.person_id and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date and rownum=1) scheduler, xxen_util.yes(coo.enable_cum_flag) enable_cum, (select ccp.cum_period_start_date from chv_cum_periods ccp where ccp.organization_id=csi.organization_id and sysdate between ccp.cum_period_start_date and ccp.cum_period_end_date and rownum=1) cum_start_date, csi.starting_cum_quantity starting_cum_quantity, (select rsh.shipment_num from rcv_transactions rct, rcv_shipment_headers rsh where rct.transaction_id=csi.last_receipt_transaction_id and rct.shipment_header_id=rsh.shipment_header_id) last_receipt_number, (select rct.quantity from rcv_transactions rct where rct.transaction_id=csi.last_receipt_transaction_id) last_receipt_quantity, (select xxen_util.meaning(ca.authorization_code,'AUTHORIZATION_TYPE',201) from chv_authorizations ca where ca.reference_type='SCHEDULE_ITEMS' and ca.authorization_sequence=1 and ca.reference_id=csi.schedule_item_id and rownum=1) auth1_type, (select ca.schedule_quantity from chv_authorizations ca where ca.reference_type='SCHEDULE_ITEMS' and ca.authorization_sequence=1 and ca.reference_id=csi.schedule_item_id and rownum=1) auth1_quantity, (select xxen_util.meaning(ca.authorization_code,'AUTHORIZATION_TYPE',201) from chv_authorizations ca where ca.reference_type='SCHEDULE_ITEMS' and ca.authorization_sequence=2 and ca.reference_id=csi.schedule_item_id and rownum=1) auth2_type, (select ca.schedule_quantity from chv_authorizations ca where ca.reference_type='SCHEDULE_ITEMS' and ca.authorization_sequence=2 and ca.reference_id=csi.schedule_item_id and rownum=1) auth2_quantity, (select xxen_util.meaning(ca.authorization_code,'AUTHORIZATION_TYPE',201) from chv_authorizations ca where ca.reference_type='SCHEDULE_ITEMS' and ca.authorization_sequence=3 and ca.reference_id=csi.schedule_item_id and rownum=1) auth3_type, (select ca.schedule_quantity from chv_authorizations ca where ca.reference_type='SCHEDULE_ITEMS' and ca.authorization_sequence=3 and ca.reference_id=csi.schedule_item_id and rownum=1) auth3_quantity, (select xxen_util.meaning(ca.authorization_code,'AUTHORIZATION_TYPE',201) from chv_authorizations ca where ca.reference_type='SCHEDULE_ITEMS' and ca.authorization_sequence=4 and ca.reference_id=csi.schedule_item_id and rownum=1) auth4_type, (select ca.schedule_quantity from chv_authorizations ca where ca.reference_type='SCHEDULE_ITEMS' and ca.authorization_sequence=4 and ca.reference_id=csi.schedule_item_id and rownum=1) auth4_quantity, b.bucket_seq, xxen_util.meaning(b.bucket_type_code,'SCHEDULE_BUCKET_TYPE',201) bucket_type, to_date(b.bucket_start_str,'YYYY/MM/DD') bucket_start_date, to_date(b.bucket_end_str,'YYYY/MM/DD') bucket_end_date, to_number(b.forecast_qty_str) forecast_quantity, to_number(b.release_qty_str) released_quantity, to_number(b.total_qty_str) total_quantity, to_number(b.cum_qty_str) cum_quantity from ( select hs.schedule_id, hs.schedule_item_id, hs.bucket_seq, max(case when hs.row_type='BUCKET_DESCRIPTOR' then hs.cell end) bucket_type_code, max(case when hs.row_type='BUCKET_START_DATE' then hs.cell end) bucket_start_str, max(case when hs.row_type='BUCKET_END_DATE' then hs.cell end) bucket_end_str, max(case when hs.row_type='RELEASE_QUANTITY' then hs.cell end) release_qty_str, max(case when hs.row_type='FORECAST_QUANTITY' then hs.cell end) forecast_qty_str, max(case when hs.row_type='TOTAL_QUANTITY' then hs.cell end) total_qty_str, max(case when hs.row_type='CUM_QUANTITY' then hs.cell end) cum_qty_str from ( select chs.schedule_id, chs.schedule_item_id, chs.row_type, rg.column_value bucket_seq, decode(rg.column_value,1,chs.column1,2,chs.column2,3,chs.column3,4,chs.column4,5,chs.column5,6,chs.column6,7,chs.column7,8,chs.column8,9,chs.column9,10,chs.column10,11,chs.column11,12,chs.column12,13,chs.column13,14,chs.column14,15,chs.column15,16,chs.column16,17,chs.column17,18,chs.column18,19,chs.column19,20,chs.column20,21,chs.column21,22,chs.column22,23,chs.column23,24,chs.column24,25,chs.column25,26,chs.column26,27,chs.column27,28,chs.column28,29,chs.column29,30,chs.column30,31,chs.column31,32,chs.column32,33,chs.column33,34,chs.column34,35,chs.column35,36,chs.column36,37,chs.column37,38,chs.column38,39,chs.column39,40,chs.column40,41,chs.column41,42,chs.column42,43,chs.column43,44,chs.column44,45,chs.column45,46,chs.column46,47,chs.column47,48,chs.column48,49,chs.column49,50,chs.column50,51,chs.column51,52,chs.column52,53,chs.column53,54,chs.column54,55,chs.column55,56,chs.column56,57,chs.column57,58,chs.column58,59,chs.column59,60,chs.column60) cell from chv_horizontal_schedules chs, table(xxen_util.rowgen(60)) rg where chs.row_type in ('BUCKET_DESCRIPTOR','BUCKET_START_DATE','BUCKET_END_DATE','RELEASE_QUANTITY','FORECAST_QUANTITY','TOTAL_QUANTITY','CUM_QUANTITY') ) hs group by hs.schedule_id, hs.schedule_item_id, hs.bucket_seq having max(case when hs.row_type='BUCKET_DESCRIPTOR' then hs.cell end) is not null ) b, chv_schedule_items csi, chv_schedule_headers csh, chv_bucket_patterns cbp, chv_org_options coo, mtl_system_items_b_kfv msibk, org_organization_definitions ood, po_vendors pov, po_vendor_sites_all povs, po_headers_all poh where b.schedule_id=csi.schedule_id and b.schedule_item_id=csi.schedule_item_id and csi.schedule_id=csh.schedule_id and csh.bucket_pattern_id=cbp.bucket_pattern_id and csi.organization_id=coo.organization_id(+) and csi.item_id=msibk.inventory_item_id and csi.organization_id=msibk.organization_id and csi.organization_id=ood.organization_id and csh.vendor_id=pov.vendor_id and csh.vendor_site_id=povs.vendor_site_id and csi.po_header_id=poh.po_header_id(+) and nvl(csi.item_purge_status,'ACTIVE')<>'PURGED' and ( csi.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) and 1=1 order by csh.schedule_num, msibk.concatenated_segments, b.bucket_seq Migration of standard CHVPRSCH_XML (Printed Planning Schedule, XML) to Blitz Report. Hierarchical BIP data template (Q_HEADERS/Q_ITEMS/Q_1..Q_6/Q_Auth_1..4) flattened: the chv_horizontal_schedules 60-column bucket grid is un-pivoted to one row per schedule/item/bucket; schedule header, item, CUM period and the 4 CUM authorization levels are joined as context. 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 Migration of the Oracle standard concurrent program Printed Planning Schedule (XML) (CHVPRSCH_XML) from Supplier Scheduling. Shows, for each confirmed planning/shipping schedule, the time-phased demand grid sent to the supplier - one row per schedule, item and time bucket - with forecast, released, total and cumulative (CUM+) quantities per bucket, plus the schedule header, item, CUM and authorization context. The horizontal schedule grid (chv_horizontal_schedules, up to 60 bucket columns) is un-pivoted into rows for analysis in Excel. ZHS PO 打印计划进度表 Imported from BI Publisher Description: 打印计划进度表报表 Application: 采购管理系统 Source: 打印计划进度表 (XML) Short Name: CHVPRSCH_XML DB package: PO_CHVPRSCH_XMLP_PKG Enginatics 1=1 1 10 1=1 ood.organization_code=:organization LOV custom Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood, mtl_parameters mp where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and nvl(ood.disable_date,sysdate)>=sysdate and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) order by ood.organization_code 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 Organization ZHS 计划编号 计划编号 2 20 1=1 pov.vendor_name=:supplier LOV AP Supplier B9847D20A0E4742FE0538931640A6379 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id 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 Supplier ZHS 计划版本 计划版本 3 30 1=1 povs.vendor_site_code=:supplier_site LOV custom Y select assa.vendor_site_code value, assa.vendor_site_code description from ap_suppliers aps, ap_supplier_sites_all assa where aps.vendor_id=assa.vendor_id and (:$flex$.supplier is null or xxen_util.contains(:$flex$.supplier,aps.vendor_name)='Y') order by assa.vendor_site_code 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 Supplier Site ZHS 计划子类型 计划子类型 4 40 1=1 csh.schedule_type=:schedule_type LOV custom Y select 'PLAN_SCHEDULE' id, 'Planning' value, null description from dual union all select 'SHIP_SCHEDULE' id, 'Shipping' value, null description from dual 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 Schedule Type ZHS 展望期起始 展望期起始 5 50 1=1 csh.schedule_num=:schedule_number LOV custom Y select csh.schedule_num value, pov.vendor_name description from chv_schedule_headers csh, po_vendors pov where csh.vendor_id=pov.vendor_id order by csh.schedule_num 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 Schedule Number ZHS 展望期终止日期 展望期终止日期 6 60 1=1 csh.schedule_status=:schedule_status LOV custom Y select plc.lookup_code id, plc.displayed_field value, null description from po_lookup_codes plc where plc.lookup_type='SCHEDULE_STATUS' order by plc.displayed_field 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 Schedule Status ZHS 起始供应商 起始供应商 7 70 1=1 csh.schedule_horizon_start>=:horizon_from Date 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 Horizon From ZHS 供应商至 供应商至 8 80 1=1 csh.schedule_horizon_start<:horizon_to+1 Date 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 Horizon To ZHS 供应商地点 供应商地点 9 90 1=1 (to_number(b.forecast_qty_str)<>0 or to_number(b.release_qty_str)<>0 or to_number(b.total_qty_str)<>0 or to_number(b.cum_qty_str)<>0) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y Y 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 Exclude Zero Quantity Buckets ZHS 测试打印 测试打印