ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN CECC17E2BCD78874E0530100007F7C8D PI Cycle Count From Y select distinct ipc.count_no id, ipc.count_no value, null description from ic_phys_cnt ipc, ic_cycl_hdr ich where ipc.cycle_id=ich.cycle_id and (:$flex$.cycle is null or xxen_util.contains(:$flex$.cycle,ich.cycle_no)='Y') order by ipc.count_no asc US CECC17E2BCD88874E0530100007F7C8D PI Cycle Count To Y select distinct ipc.count_no id, ipc.count_no value, null description from ic_phys_cnt ipc, ic_cycl_hdr ich where ipc.cycle_id=ich.cycle_id and (:$flex$.cycle is null or xxen_util.contains(:$flex$.cycle,ich.cycle_no)='Y') and ipc.count_no>=:$flex$.from_count order by ipc.count_no asc US CECC17E2BCD68874E0530100007F7C8D PI Cycle Number Y select ich.cycle_no value, ich.cycle_desc description from ic_cycl_hdr ich where ich.cycle_source=1 and (:$flex$.warehouse_code is null or xxen_util.contains(:$flex$.warehouse_code,ich.whse_code)='Y') order by ich.cycle_no US CECC17E2BCD58874E0530100007F7C8D PI Warehouse Code Y select iwm.whse_code value, iwm.whse_name description from ic_whse_mst iwm order by iwm.whse_code, iwm.whse_name US CDA69B7E2F0BE88CE05362FB0905154A select distinct ipc.whse_code warehouse, iwm.whse_name warehouse_description, ich.cycle_no, ich.cycle_desc, item_no item_number, item_desc1 item_description, ilm.lot_no lot, ilm.lot_desc lot_description, ilm.sublot_no sublot, ipc.location, ipc.grade_code, iimv.item_um item_uom, iimv.item_um2 item_uom2, ipc.count_no, mod(ipc.count_no,1000) line_no, trunc(ipc.count_no/1000) page_no, ich.print_format from ic_whse_mst iwm, ic_phys_cnt ipc, ic_cycl_hdr ich, ic_item_mst_vl iimv, ic_lots_mst ilm where 1=1 and iwm.whse_code=ipc.whse_code and ipc.delete_mark=0 and ipc.cycle_id=ich.cycle_id and ipc.item_id=iimv.item_id and ipc.item_id=ilm.item_id and ipc.lot_id=ilm.lot_id order by count_no Y GMI AR GMI نماذج العد الدوري (بتنسيق XML) Imported from BI Publisher Description: تقرير نماذج العد الدوري لمخزون OPM الفعلي لأوراكل Application: مخازن التصنيع التشغيلي Source: نماذج العد الدوري (بتنسيق XML) Short Name: PIR05_XML DB package: GMI_PIR05_XMLP_PKG D GMI Permanente Inventur - Formulare Imported from BI Publisher Description: Auswertung "Permanente Inventur - Formulare" in Oracle OPM PI Application: Process Manufacturing Materialwirtschaft Source: Permanente Inventur - Formulare (XML) Short Name: PIR05_XML DB package: GMI_PIR05_XMLP_PKG E GMI Pantallas de Recuento Cíclico Imported from BI Publisher Description: Informe de pantallas de recuento cíclico de inventario físico de Oracle OPM Application: Process Manufacturing Inventory Source: Pantallas de Recuento Cíclico (XML) Short Name: PIR05_XML DB package: GMI_PIR05_XMLP_PKG F GMI Formulaires d'inventaire tournant Imported from BI Publisher Description: Formulaires d'inventaire tournant - OPM PI Application: Process Manufacturing Inventory Source: Formulaires d'inventaire tournant (XML) Short Name: PIR05_XML DB package: GMI_PIR05_XMLP_PKG I GMI Modelli inventario ciclico Imported from BI Publisher Description: Rapporto Modelli inventario ciclico di Oracle OPM PI Application: Process Manufacturing Inventory Source: Modelli inventario ciclico (XML) Short Name: PIR05_XML DB package: GMI_PIR05_XMLP_PKG JA GMI 循環棚卸フォーム Imported from BI Publisher Description: Oracle OPM PI循環棚卸フォーム・レポート Application: Process Manufacturing Inventory Source: 循環棚卸フォーム(XML) Short Name: PIR05_XML DB package: GMI_PIR05_XMLP_PKG KO GMI 주기 실사 화면 Imported from BI Publisher Description: Oracle OPM PI의 주기 실사 화면 보고서 Application: Process Manufacturing Inventory Source: 주기 실사 화면(XML) Short Name: PIR05_XML DB package: GMI_PIR05_XMLP_PKG PTB GMI Forms Contagem Cíclica Imported from BI Publisher Description: Relatório de Forms de Contagem Cíclica de OPM PI Oracle Application: Process Manufacturing Inventory Source: Forms Contagem Cíclica (XML) Short Name: PIR05_XML DB package: GMI_PIR05_XMLP_PKG RU GMI Формы периодической инвентаризации Imported from BI Publisher Description: Формы периодической инвентаризации ОИ УНП Application: Запасы УНП Source: Формы периодической инвентаризации (XML) Short Name: PIR05_XML DB package: GMI_PIR05_XMLP_PKG S GMI Formulär för cyklisk inventering Imported from BI Publisher Description: Formulär för cyklisk inventering i Oracle OPM LI - rapport Application: Process Manufacturing Inventory Source: Formulär för cyklisk inventering (XML) Short Name: PIR05_XML DB package: GMI_PIR05_XMLP_PKG TR GMI Dönemsel Sayım Ekranları Imported from BI Publisher Description: Oracle OPM PI Dönemsel Sayım Ekranları Raporu Application: Üretim Prosesi Stok Yönetimi Source: Dönemsel Sayım Ekranları (XML) Short Name: PIR05_XML DB package: GMI_PIR05_XMLP_PKG US GMI Cycle Count Forms Imported Oracle standard Cycle Count Forms Report of Oracle OPM PI report Source: Cycle Count Forms (XML) Short Name: PIR05_XML DB package: GMI_PIR05_XMLP_PKG ZHS GMI 周期盘点表单 Imported from BI Publisher Description: Oracle OPM PI 的周期盘点表单报表 Application: OPM 库存管理系统 Source: 周期盘点表单 (XML) Short Name: PIR05_XML DB package: GMI_PIR05_XMLP_PKG Enginatics 1=1 1 10 1=1 ipc.whse_code=:p_warehouse LOV PI Warehouse Code CECC17E2BCD58874E0530100007F7C8D Y select iwm.whse_code value, iwm.whse_name description from ic_whse_mst iwm order by iwm.whse_code, iwm.whse_name AR رمز المستودع رمز المستودع D Lagercode Lagercode E Código de Almacén Código de Almacén F Code de l'entrepôt Code entrepôt I Codice warehouse Codice warehouse JA 倉庫コード 倉庫コード KO 창고 코드 창고 코드 PTB Código do Depósito Código do Depósito RU Код склада Код склада S Lagerkod Lagerkod TR Depo Kodu Depo Kodu US Warehouse Code Warehouse Code ZHS 仓库代码 仓库代码 2 20 1=1 ich.cycle_no=:p_cycle_no LOV PI Cycle Number CECC17E2BCD68874E0530100007F7C8D Y select ich.cycle_no value, ich.cycle_desc description from ic_cycl_hdr ich where ich.cycle_source=1 and (:$flex$.warehouse_code is null or xxen_util.contains(:$flex$.warehouse_code,ich.whse_code)='Y') order by ich.cycle_no AR الدورة الدورة D Inventur Inventur E Ciclo Ciclo F Inventaire Inventaire I Ciclo Ciclo JA 循環 循環 KO 주기 실사 주기 실사 PTB Ciclo Ciclo RU Цикл Цикл S Cykel Cykel TR Döngü Döngü US Cycle Cycle ZHS 周期 周期 3 30 1=1 ipc.count_no>=:p_from_count LOV PI Cycle Count From CECC17E2BCD78874E0530100007F7C8D Y select distinct ipc.count_no id, ipc.count_no value, null description from ic_phys_cnt ipc, ic_cycl_hdr ich where ipc.cycle_id=ich.cycle_id and (:$flex$.cycle is null or xxen_util.contains(:$flex$.cycle,ich.cycle_no)='Y') order by ipc.count_no asc AR من الجرد من الجرد D Von Aufnahme Von Aufnahme E De Recuento De recuento F Du compte Inventaire - De I Conteggio - Da Conteggio - Da JA 棚卸:自 棚卸:自 KO 실사: 부터 실사: 부터 PTB Contagem De Contagem De RU Инвентаризация с Инвентаризация с S Från inventeringslista Från inventeringslista TR İlk Sayım İlk Sayım US From Count From Count ZHS 起始盘点 起始盘点 4 40 1=1 ipc.count_no<=:p_to_count LOV PI Cycle Count To CECC17E2BCD88874E0530100007F7C8D Y select distinct ipc.count_no id, ipc.count_no value, null description from ic_phys_cnt ipc, ic_cycl_hdr ich where ipc.cycle_id=ich.cycle_id and (:$flex$.cycle is null or xxen_util.contains(:$flex$.cycle,ich.cycle_no)='Y') and ipc.count_no>=:$flex$.from_count order by ipc.count_no asc AR إلى الجرد إلى الجرد D Bis Aufnahme Bis Aufnahme E A Recuento A recuento F Pour compter Inventaire - A I Conteggio - A Conteggio - A JA 棚卸:至 棚卸:至 KO 실사: 까지 실사: 까지 PTB Contagem - Até Contagem - Até RU Инвентаризация по Инвентаризация по S Till inventeringslista Till inventeringslista TR Son Sayım Son Sayım US To Count To Count ZHS 终止盘点 终止盘点 5 50 :sort_by LOV Oracle PI_FRM_CY_SORT_BY 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=108673 order by ffvv.flex_value AR فرز حسب فرز بواسطة D Sortieren nach Sortieren nach E Ordenar por Ordenar por F Trier par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Classificar por Classificar por RU Сортировка Сортировка S Sortera efter Sortera efter TR Sıralama Ölçütü Sıralama Ölçütü US Sort By Sort By ZHS 排序依据 排序依据 :$flex$.cycle Cycle From Count :$flex$.cycle Cycle To Count :$flex$.from_count From Count To Count :$flex$.warehouse_code Warehouse Code Cycle