ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FAB51A9E05362FB09050512 SELECT mr.subinventory_code whse_code , mil.concatenated_segments location, msik.concatenated_segments item_no, '['||msik.description||']' item_desc1, mp.organization_code plant_code, h.batch_no, rcp.recipe_no, rcp.recipe_version, d.line_no, d.inventory_item_id item_id, to_char(h.plan_start_date ,'DD-MON-YYYY HH24:MI:SS') PLAN_START_DATE, to_char(h.actual_start_date ,'DD-MON-YYYY HH24:MI:SS') actual_start_date, d.plan_qty , d.dtl_um item_um1_1, d.plan_qty plan_qty2, d.item_um2 item_um2 , d.revision, mr.lot_number lot_no, mr.primary_reservation_quantity trans_qty, msik.primary_uom_code item_um4, mr.secondary_reservation_quantity trans_qty2, msik.secondary_uom_code item_um2_1, GME_GMEBCHPL_XMLP_PKG.cf_plan_qty2formula(d.dtl_um, d.item_um2, d.inventory_item_id, d.plan_qty) CF_plan_qty2, GME_GMEBCHPL_XMLP_PKG.cf_actual_start_dateformula(h.actual_start_date) CF_actual_start_date, -- GME_GMEBCHPL_XMLP_PKG.cf_sum_trans_qtyformula(:Sum_trans_qty) CF_sum_trans_qty, -- GME_GMEBCHPL_XMLP_PKG.cf_sum_trans_qty2formula(:Sum_trans_qty2) CF_sum_trans_qty2, GME_GMEBCHPL_XMLP_PKG.cf_inv_plan_qtyformula(d.dtl_um, msik.primary_uom_code, d.inventory_item_id, d.plan_qty) CF_inv_plan_qty, GME_GMEBCHPL_XMLP_PKG.cf_trans_qtyformula(mr.primary_reservation_quantity) CF_trans_qty, GME_GMEBCHPL_XMLP_PKG.cf_trans_qty2formula(mr.secondary_reservation_quantity) CF_trans_qty2 FROM mtl_system_items_kfv msik, gmd_recipes rcp, gmd_recipe_validity_rules val, gme_batch_header h, gme_material_details d, mtl_reservations mr, mtl_item_locations_kfv mil, mtl_parameters mp WHERE h.recipe_validity_rule_id = val.recipe_validity_rule_id(+) and mp.organization_id = h.organization_id and val.recipe_id = rcp.recipe_id (+) and mr.organization_id = mil.organization_id(+) and mr.locator_id = mil.inventory_location_id(+) and mr.inventory_item_id (+) = d.inventory_item_id and mr.demand_source_type_id (+) = 5 and mr.demand_source_header_id (+) = d.batch_id and mr.demand_source_line_id (+) = d.material_detail_id and d.organization_id = msik.organization_id and d.inventory_item_id = msik.inventory_item_id and d.line_type = -1 and h.batch_id = d.batch_id and h.delete_mark = 0 and (h.batch_status = 1 or h.batch_status = 2) and h.organization_id = :P_ORG_ID &CF_BatchRange &CF_WhseRange and ((plan_start_date >= :c_fromdate) or (:c_fromdate IS NULL )) and ((plan_start_date < :c_todate+1) or (:c_todate IS NULL)) &CF_SortBy Y GME GMEBCHPL_XML AR GME قائمة انتقاء التشغيلة Imported from BI Publisher Description: تقرير قائمة لقط المجموعة لـ OPM Application: تنفيذ عمليات التصنيع التشغيلي Source: قائمة انتقاء التشغيلة (XML) Short Name: GMEBCHPL_XML DB package: GME_GMEBCHPL_XMLP_PKG D GME Materialentnahmeliste Imported from BI Publisher Description: Auswertung "Materialentnahmeliste" in OPM Application: Process Manufacturing Prozessfertigung Source: Materialentnahmeliste (XML) Short Name: GMEBCHPL_XML DB package: GME_GMEBCHPL_XMLP_PKG E GME Lista de Acopio de Lotes Imported from BI Publisher Description: Informe Lista de Acopio de Lotes de OPM Application: Process Manufacturing Process Execution Source: Lista de Acopio de Lotes (XML) Short Name: GMEBCHPL_XML DB package: GME_GMEBCHPL_XMLP_PKG F GME Liste à servir de batch Imported from BI Publisher Description: Etat Liste à servir batch - OPM Application: Process Manufacturing Process Execution Source: Liste à servir de batch (XML) Short Name: GMEBCHPL_XML DB package: GME_GMEBCHPL_XMLP_PKG I GME Elenco di selezione batch Imported from BI Publisher Description: Rapporto Elenco di selezione batch (OPM) Application: Process Manufacturing Process Execution Source: Elenco di selezione batch (XML) Short Name: GMEBCHPL_XML DB package: GME_GMEBCHPL_XMLP_PKG JA GME バッチ・ピック・リスト Imported from BI Publisher Description: OPMのバッチ・ピック・リスト・レポート Application: Process Manufacturing Process Execution Source: バッチ・ピック・リスト(XML) Short Name: GMEBCHPL_XML DB package: GME_GMEBCHPL_XMLP_PKG KO GME 배치 출하 목록 Imported from BI Publisher Description: OPM 뱃치 출하 목록 보고서 Application: Process Manufacturing Process Execution Source: 배치 출하 목록(XML) Short Name: GMEBCHPL_XML DB package: GME_GMEBCHPL_XMLP_PKG PTB GME Lista de Separação de Lotes Imported from BI Publisher Description: Relatório de Lista de Separação da Ordem de Produção do OPM Application: Process Manufacturing Process Execution Source: Lista de Separação de Lotes (XML) Short Name: GMEBCHPL_XML DB package: GME_GMEBCHPL_XMLP_PKG RU GME Ведомость комплектации Imported from BI Publisher Description: УНП: ведомость комплектации заданий Application: Реализация производственного процесса УНП Source: Ведомость комплектации (XML) Short Name: GMEBCHPL_XML DB package: GME_GMEBCHPL_XMLP_PKG S GME Batchplocklista Imported from BI Publisher Description: Batchplocklista i OPM - rapport Application: Process Manufacturing Process Execution Source: Batchplocklista (XML) Short Name: GMEBCHPL_XML DB package: GME_GMEBCHPL_XMLP_PKG TR GME İş Emri Seçme Listesi Imported from BI Publisher Description: OPM İş Emri Toplama Listesi Raporu Application: Üretim Prosesi Proses Yürütme Yönetimi Source: İş Emri Seçme Listesi (XML) Short Name: GMEBCHPL_XML DB package: GME_GMEBCHPL_XMLP_PKG US GME Batch Pick List Imported from BI Publisher Description: Batch Pick List Report of OPM Application: Process Manufacturing Process Execution Source: Batch Pick List (XML) Short Name: GMEBCHPL_XML DB package: GME_GMEBCHPL_XMLP_PKG ZHS GME 批挑库单 Imported from BI Publisher Description: OPM 批挑库单报表 Application: OPM 流程执行管理系统 Source: 批挑库单 (XML) Short Name: GMEBCHPL_XML DB package: GME_GMEBCHPL_XMLP_PKG BI Publisher &cf_batchrange &cf_sortby &cf_whserange :c_fromdate :c_todate :cp_batchrange :cp_daterange :cp_sortby :cp_whserange :frombatch :fromdate :fromwhse :nonblocksql :p_code :p_conc_request_id :p_org_id :sortby :sy_min_date :tobatch :todate :towhse 1 -20 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR التنظيم التنظيم D Organisation Organisation E Organización Organización F Organisation Organisation I Organizzazione Organizzazione JA 組織 組織 KO 조직 조직 PTB Organização Organização RU Организация Организация S Organisation Organisation TR Organizasyon Organizasyon US Organization Organization ZHS 组织 组织 2 10 :frombatch LOV Oracle GME_BATCH_PEND_WIP 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 in (1,2) and delete_mark=0 order by batch_id 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 :tobatch LOV Oracle GME_BATCH_PEND_WIP 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 in (1,2) and delete_mark=0 order by batch_id :$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 :fromwhse LOV Oracle GME_SUBINVENTORY Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by 1 AR من المخزن من المخزن D Von Lager Von Lager E De Subalmacén De Subalmacén F Magasin - De Magasin - De I Sottomagazzino - Da Sottomagazzino - Da JA 保管場所:自 保管場所:自 KO 시작 창고 시작 창고 PTB De Subinventário De Subinventário RU Складское подразделение-отправитель Складское подразделение-отправитель S Från lagerställe Från lagerställe TR İlk Stok Yeri İlk Stok Yeri US From Subinventory From Subinventory ZHS 起始子库存 起始子库存 5 40 :towhse LOV Oracle GME_SUBINVENTORY Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by 1 :$flex$.from_subinventory AR إلى المخزن إلى المخزن D Bis Lager Bis Lager E A Subalmacén A Subalmacén F Magasin - A Magasin - A I Sottomagazzino - A Sottomagazzino - A JA 保管場所:至 保管場所:至 KO 종료 창고 종료 창고 PTB Para Subinventário Para Subinventário RU Складское подразделение-получатель Складское подразделение-получатель S Till lagerställe Till lagerställe TR Son Stok Yeri Son Stok Yeri US To Subinventory To Subinventory ZHS 终止子库存 终止子库存 6 50 :fromdate 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 自计划起始日期 自起始日期 7 60 :todate 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 至计划起始日期 起始日期上限 8 70 :sortby LOV Oracle GMEBCHPL_SORT_BY Y select lookup_code id, meaning value, null description from gem_lookups where lookup_type='PM_RIPMIUSR_SORT' and enabled_flag='Y' order by value,description SELECT MEANING,NULL,1 FROM GEM_LOOKUPS WHERE LOOKUP_TYPE = 'PM_RIPMIUSR_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 :$flex$.from_subinventory From Subinventory To Subinventory