ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FAC51A9E05362FB09050512 select mp.organization_code plant_code, pm_btch_hdr.batch_id, pm_btch_hdr.routing_id, pm_btch_hdr.batch_no, fm_form_mst.formula_no, fm_form_mst.formula_vers, rt.routing_no, rt.routing_vers, rcp.recipe_no, rcp.recipe_version, pm_btch_hdr.plan_start_date, pm_btch_hdr.plan_cmplt_date expct_cmplt_date, pm_btch_hdr.due_date, pm_btch_hdr.wip_whse_code, pm_matl_dtl.line_no, msik.concatenated_segments item_no, pm_matl_dtl.revision, msik.description item_desc1, pm_matl_dtl.subinventory, mil.concatenated_segments locator, pm_matl_dtl.plan_qty, pm_matl_dtl.dtl_um item_um, pm_matl_dtl.line_type, gem_lookups.meaning, pm_btch_hdr.text_code textcode1, pm_matl_dtl.text_code textcode2, GME_GMEBCHTK_XMLP_PKG.cf_subinv_labelformula(pm_matl_dtl.line_type) CF_subinv_label, gem_lookups.meaning meaningCF, GME_GMEBCHTK_XMLP_PKG.flagcfformula(pm_matl_dtl.text_code) flagCF, GME_GMEBCHTK_XMLP_PKG.R_batchFormatTrigger(pm_btch_hdr.batch_no) R_batch_ft from fm_form_mst, mtl_system_items_kfv msik, gmd_routings_b rt, gmd_recipes rcp, gmd_recipe_validity_rules rcpv, gme_batch_header pm_btch_hdr, gme_material_details pm_matl_dtl, gem_lookups, mtl_item_locations_kfv mil, mtl_parameters mp where pm_btch_hdr.organization_id = mp.organization_id and mp.organization_id = :P_ORG_ID and fm_form_mst.formula_id (+) = pm_btch_hdr.formula_id and pm_matl_dtl.batch_id = pm_btch_hdr.batch_id and gem_lookups.lookup_type= 'LINE_TYPE' and gem_lookups.lookup_code = pm_matl_dtl.line_type and pm_matl_dtl.locator_id = mil.inventory_location_id(+) and pm_matl_dtl.organization_id = mil.organization_id(+) and msik.organization_id = pm_matl_dtl.organization_id and msik.inventory_item_id = pm_matl_dtl.inventory_item_id and pm_btch_hdr.delete_mark = 0 and pm_btch_hdr.batch_type = 0 and pm_btch_hdr.batch_status != -1 and pm_btch_hdr.routing_id = rt.routing_id(+) and pm_btch_hdr.recipe_validity_rule_id = rcpv.recipe_validity_rule_id(+) and rcpv.recipe_id = rcp.recipe_id(+) and &RangeCF1 and ( pm_btch_hdr.plan_start_date >= :from_start_date_1 OR :from_start_date_1 IS NULL) and ( pm_btch_hdr.plan_start_date < (:to_start_date_1+1) OR :to_start_date IS NULL) order by &OrdCF Y GME GMEBCHTK_XML AR GME تذكرة التشغيلة Imported from BI Publisher Description: تقرير تذكرة المجموعة لـ OPM Application: تنفيذ عمليات التصنيع التشغيلي Source: تذكرة التشغيلة (XML) Short Name: GMEBCHTK_XML DB package: GME_GMEBCHTK_XMLP_PKG D GME Produktionsauftragspapiere Imported from BI Publisher Description: Auswertung "Produktionsauftragspapiere" in OPM Application: Process Manufacturing Prozessfertigung Source: Produktionsauftragspapiere (XML) Short Name: GMEBCHTK_XML DB package: GME_GMEBCHTK_XMLP_PKG E GME Tarjeta de Lote Imported from BI Publisher Description: Informe Tarjeta de Lote de OPM Application: Process Manufacturing Process Execution Source: Tarjeta de Lote (XML) Short Name: GMEBCHTK_XML DB package: GME_GMEBCHTK_XMLP_PKG F GME Fiche de production Imported from BI Publisher Description: Etat Fiches de production - OPM Application: Process Manufacturing Process Execution Source: Fiche de production (XML) Short Name: GMEBCHTK_XML DB package: GME_GMEBCHTK_XMLP_PKG I GME Scheda batch Imported from BI Publisher Description: Rapporto Scheda batch (OPM) Application: Process Manufacturing Process Execution Source: Scheda batch (XML) Short Name: GMEBCHTK_XML DB package: GME_GMEBCHTK_XMLP_PKG JA GME バッチ・チケット Imported from BI Publisher Description: OPMのバッチ・チケット・レポート Application: Process Manufacturing Process Execution Source: バッチ・チケット(XML) Short Name: GMEBCHTK_XML DB package: GME_GMEBCHTK_XMLP_PKG KO GME 배치 티켓 Imported from BI Publisher Description: OPM 뱃치 티켓 보고서 Application: Process Manufacturing Process Execution Source: 배치 티켓(XML) Short Name: GMEBCHTK_XML DB package: GME_GMEBCHTK_XMLP_PKG PTB GME Bilhete da ordem de produção Imported from BI Publisher Description: Relatório de Bilhete da Ordem de produção do OPM Application: Process Manufacturing Process Execution Source: Bilhete da ordem de produção (XML) Short Name: GMEBCHTK_XML DB package: GME_GMEBCHTK_XMLP_PKG RU GME Наряд-заказ на задание Imported from BI Publisher Description: УНП: отчет о нарядах-заказах на задания Application: Реализация производственного процесса УНП Source: Наряд-заказ на задание (XML) Short Name: GMEBCHTK_XML DB package: GME_GMEBCHTK_XMLP_PKG S GME Batchföljesedel Imported from BI Publisher Description: Batchföljesedel i OPM - rapport Application: Process Manufacturing Process Execution Source: Batchföljesedel (XML) Short Name: GMEBCHTK_XML DB package: GME_GMEBCHTK_XMLP_PKG TR GME İş Emri Fişi Imported from BI Publisher Description: OPM İş Emri Kartı Raporu Application: Üretim Prosesi Proses Yürütme Yönetimi Source: İş Emri Fişi (XML) Short Name: GMEBCHTK_XML DB package: GME_GMEBCHTK_XMLP_PKG US GME Batch Ticket Imported from BI Publisher Description: Batch Ticket Report of OPM Application: Process Manufacturing Process Execution Source: Batch Ticket (XML) Short Name: GMEBCHTK_XML DB package: GME_GMEBCHTK_XMLP_PKG ZHS GME 批标签 Imported from BI Publisher Description: OPM 批标签报表 Application: OPM 流程执行管理系统 Source: 批标签 (XML) Short Name: GMEBCHTK_XML DB package: GME_GMEBCHTK_XMLP_PKG BI Publisher &ordcf &rangecf1 :cnttext :from_batch_no :from_start_date :from_start_date1 :from_start_date_1 :nonblocksql :p_conc_request_id :p_org_id :p_orgn :p_rows :sort_by :to_batch_no :to_start_date :to_start_date1 :to_start_date_1 1 -20 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR تنظيم (بدون عرض) تنظيم (بدون عرض) D Organisation (Nicht angezeigt) Organisation (Nicht angezeigt) E Organización(No Mostrada) Organización (no mostrada) F Organisation (non affichée) Organisation (non affichée) I Organizzazione (non visualizzata) Organizzazione (non visualizzata) JA 組織(非表示) 組織(非表示) KO 조직(표시 안함) 조직(표시되지 않음) PTB Organização(Não-Exibição) Organização(Não-Exibição) RU Организация (не отображается) Организация (не выводится) S Organisation (ej visning) Organisation (ej visning) TR Organizasyon(Görüntü Yok) Organizasyon (Görüntü Yok) US Organization(Non Display) Organization (Non Display) ZHS 组织（未显示） 组织（未显示） 2 10 :from_batch_no LOV Oracle GME_BT_BATCH_NO Y select batch_no id, batch_no value, null description from gme_batch_header where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and batch_type=0 and batch_status<>-1 and delete_mark=0 order by batch_no AR من التشغيلة من رقم المجموعة D Von Produktionsauftrag Von Produktionsauftragsnummer E De Lote De Número de Lote F Batch - De Numéro de batch - De I Batch - Da N. batch - Da JA バッチ:自 バッチ番号:自 KO 시작 뱃치 뱃치 번호: 부터 PTB Ordem Prod. - De Nº da O.Prod. - De RU Задание с Номер задания с S Från batch Från batchnr TR İlk İş Emri İlk İş Emri No US From Batch From Batch No ZHS 自批 起始批号 3 20 :to_batch_no LOV Oracle GME_BT_BATCH_NO Y select batch_no id, batch_no value, null description from gme_batch_header where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and batch_type=0 and batch_status<>-1 and delete_mark=0 order by batch_no :$flex$.from_batch AR إلى التشغيلة إلى رقم المجموعة D Bis Produktionsauftrag Bis Produktionsauftragsnummer E A Lote A Número de Lote F Batch - A Numéro de batch - A I Batch - A N. batch - A JA バッチ:至 バッチ番号:至 KO 종료 뱃치 뱃치 번호: 까지 PTB OP - Até Nº da ordem de produção - Até RU Задание по Номер задания по S Till batch Till batchnr TR Son İş Emri Son İş Emri No US To Batch To Batch No ZHS 至批 终止批号 4 30 :from_start_date Date AR من تاريخ البداية المخطط من تاريخ البداية D Von Geplantes Startdatum Von Startdatum E De Fecha de Inicio Planificada De Fecha de Inicio F Date de début planifiée - Du Date de début - De I Data inizio pianificata - Da Data inizio - Da JA 計画開始日:自 開始日:自 KO 시작 계획 시작 일자 시작 일자: 부터 PTB Da Data Inicial Planejada Data Inicial - De RU Плановая начальная дата с Начальная дата с S Från planerat startdatum Från startdatum TR İlk Planlı Başlangıç Tarihi İlk Başlangıç Tarihi US From Planned Start Date From Start Date ZHS 自计划起始日期 自起始日期 5 40 :to_start_date Date :$flex$.from_planned_start_date AR إلى تاريخ البداية المخطط إلى تاريخ البداية D Bis Geplantes Startdatum Bis Startdatum E A Fecha de Inicio Planificada A Fecha de Inicio F Date de début planifiée - Au Date de début - A I Data inizio pianificata - A Data inizio - A JA 計画開始日:至 開始日:至 KO 종료 계획 시작 일자 시작 일자: 까지 PTB Até a Data Inicial Planejada Data Inicial - Até RU Плановая дата начала по Начальная дата по S Till planerat startdatum Till startdatum TR Son Planlı Başlangıç Tarihi Son Başlangıç Tarihi US To Planned Start Date To Start Date ZHS 至计划起始日期 起始日期上限 6 50 :sort_by LOV Oracle GMEBTICKET_SORT_BY Y select lookup_code id, meaning value, null description from gem_lookups where lookup_type='PM_RIPMBUSR_SORT' and enabled_flag='Y' order by value,description SELECT MEANING,NULL,1 FROM GEM_LOOKUPS WHERE LOOKUP_TYPE = 'PM_RIPMBUSR_SORT' AND ENABLED_FLAG = 'Y' AND LOOKUP_CODE = 1 Y AR فرز بواسطة فرز بواسطة D Sortieren nach Sortieren nach E Ordenar por Ordenar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Classificar por Classificar por RU Сортировка Сортировка S Sortera efter Sortera efter TR Sıralama Esası Sıralama Esası US Sort By Sort By ZHS 排序依据 排序依据 :$flex$.from_batch From Batch To Batch :$flex$.from_planned_start_date From Planned Start Date Y To Planned Start Date