ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FB051A9E05362FB09050512 SELECT pm.batch_no, rcp.recipe_no , rcp.recipe_version , to_char(pm.plan_start_date,'DD-MON-YYYY HH24:MI:SS') plan_start_date , to_char(pm.plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS') expct_cmplt_date , pm.batch_type, GME_GMEPRACT_XMLP_PKG.cf_batch_typeformula(pm.batch_type) CF_batch_type FROM gme_batch_header pm, gmd_recipes rcp, gmd_recipe_validity_rules val WHERE &cf_where and (plan_start_date >= :from_date1 OR :from_date1 IS NULL) and (plan_start_date < (:to_date1+1) OR :to_date1 IS NULL ) and pm.organization_id = :P_ORG_ID and pm.recipe_validity_rule_id = val.recipe_validity_rule_id(+) and val.recipe_id = rcp.recipe_id(+) and pm.delete_mark = 0 and pm.batch_status = 1 ORDER BY &Cf_ord_by Y GME GMEPRACT_XML AR GME الإنتاج المخطط Imported from BI Publisher Description: تقرير الإنتاج المخطط في OPM Application: تنفيذ عمليات التصنيع التشغيلي Source: الإنتاج المخطط (XML) Short Name: GMEPRACT_XML DB package: GME_GMEPRACT_XMLP_PKG D GME Geplante Produktion Imported from BI Publisher Description: Auswertung "Geplante Produktion" in OPM Application: Process Manufacturing Prozessfertigung Source: Geplante Produktion (XML) Short Name: GMEPRACT_XML DB package: GME_GMEPRACT_XMLP_PKG E GME Producción Planificada Imported from BI Publisher Description: Informe de producción planificada de OPM Application: Process Manufacturing Process Execution Source: Producción Planificada (XML) Short Name: GMEPRACT_XML DB package: GME_GMEPRACT_XMLP_PKG F GME Production planifiée Imported from BI Publisher Description: Etat Production planifiée - OPM Application: Process Manufacturing Process Execution Source: Production planifiée (XML) Short Name: GMEPRACT_XML DB package: GME_GMEPRACT_XMLP_PKG I GME Produzione pianificata Imported from BI Publisher Description: Rapporto Produzione pianificata di OPM Application: Process Manufacturing Process Execution Source: Produzione pianificata (XML) Short Name: GMEPRACT_XML DB package: GME_GMEPRACT_XMLP_PKG JA GME 計画生産 Imported from BI Publisher Description: OPMの計画生産レポート Application: Process Manufacturing Process Execution Source: 計画生産(XML) Short Name: GMEPRACT_XML DB package: GME_GMEPRACT_XMLP_PKG KO GME 계획 생산 Imported from BI Publisher Description: OPM의 계획 생산 보고서 Application: Process Manufacturing Process Execution Source: 계획 생산(XML) Short Name: GMEPRACT_XML DB package: GME_GMEPRACT_XMLP_PKG PTB GME Produção Planejada Imported from BI Publisher Description: Relatório de Produção Planejada do OPM Application: Process Manufacturing Process Execution Source: Produção Planejada (XML) Short Name: GMEPRACT_XML DB package: GME_GMEPRACT_XMLP_PKG RU GME Плановое производство Imported from BI Publisher Description: Отчет о плановом производстве УНП Application: Реализация производственного процесса УНП Source: Плановое производство (XML) Short Name: GMEPRACT_XML DB package: GME_GMEPRACT_XMLP_PKG S GME Planerad produktion Imported from BI Publisher Description: Rapporten Planerad produktion i OPM Application: Process Manufacturing Process Execution Source: Planerad produktion (XML) Short Name: GMEPRACT_XML DB package: GME_GMEPRACT_XMLP_PKG TR GME Planlanan Üretim Imported from BI Publisher Description: OPM Planlı Üretim Raporu Application: Üretim Prosesi Proses Yürütme Yönetimi Source: Planlanan Üretim (XML) Short Name: GMEPRACT_XML DB package: GME_GMEPRACT_XMLP_PKG US GME Planned Production Imported from BI Publisher Description: Planned Production Report of OPM Application: Process Manufacturing Process Execution Source: Planned Production (XML) Short Name: GMEPRACT_XML DB package: GME_GMEPRACT_XMLP_PKG ZHS GME 计划产量 Imported from BI Publisher Description: OPM 计划产量报表 Application: OPM 流程执行管理系统 Source: 计划产量 (XML) Short Name: GMEPRACT_XML DB package: GME_GMEPRACT_XMLP_PKG BI Publisher &cf_ord_by &cf_where :from_batch :from_date :from_date1 :from_date2 :from_date_1 :nonblocksql :orgn_code :p_conc_request_id :p_org_id :sort_by :to_batch :to_date :to_date1 :to_date2 :to_date_1 1 -20 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR التنظيم تنظيم السياق D Organisation Kontextorganisation E Organización Organización de contexto F Organisation Organisation de contexte I Organizzazione Organizzazione contesto JA 組織 コンテキスト組織 KO 조직 컨텍스트 조직 PTB Organização Organização do Contexto RU Организация Организация контекста S Organisation Sammanhangsorganisation TR Organizasyon İçerik Organizasyonu US Organization Context Organization ZHS 组织 上下文组织 2 10 :from_batch LOV Oracle GME_PROD_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_status=1 and delete_mark=0 order by batch_no AR من المستند من رقم المجموعة D Von Dokument Von Produktionsauftragsnummer E De Documento De Número de Lote F Document - De Numéro de batch - De I Documento - Da N. batch - Da JA 文書:自 バッチ番号:自 KO 시작 문서 뱃치 번호: 부터 PTB Documento - De Número da ordem de produção - De RU Документ с Номер задания с S Från dokument Från batchnummer TR İlk Doküman İlk İş Emri Numarası US From Document From Batch Number ZHS 起始文件 起始批号 3 20 :to_batch LOV Oracle GME_PROD_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_status=1 and delete_mark=0 order by batch_no AR إلى المستند إلى رقم المجموعة D Bis Dokument Bis Produktionsauftragsnummer E A Documento A Número de Lote F Document - A Numéro de batch - A I Documento - A N. batch - A JA 文書:至 バッチ番号:至 KO 종료 문서 뱃치 번호: 까지 PTB Documento - Até Número da ordem de produção - Até RU Документ по Номер задания по S Till dokument Till batchnummer TR Son Doküman Son İş Emri Numarası US To Document To Batch Number ZHS 终止文件 终止批号 4 30 :from_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_date Date AR إلى تاريخ البداية المخطط إلى تاريخ البداية D Bis Geplantes Startdatum Bis Startdatum (MJ) 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 Minha 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 my ZHS 至计划起始日期 至起始日期 - 我的 6 50 :sort_by LOV Oracle GMEPRACT_SORT_BY Y select lookup_code id, meaning value, null description from gem_lookups where lookup_type='GME_GMEPRACT_SORT' and enabled_flag='Y' order by value,description SELECT MEANING,NULL,1 FROM GEM_LOOKUPS WHERE LOOKUP_TYPE = 'GME_GMEPRACT_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 排序依据 排序依据