ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FAF51A9E05362FB09050512Y SELECT gbh.batch_id batch_id, gbh.batch_no batch_no, gl.meaning status, gbh.plan_start_date sched_start_date, gbh.plan_cmplt_date sched_cmplt_date, msib.concatenated_segments product, gmd.dtl_um uom, gmd.plan_qty scheduled_qty, gmd.actual_qty qty_completed FROM gme_batch_header gbh, gme_material_details gmd, wip_entities we, mtl_system_items_kfv msib, gem_lookups gl WHERE (:p_batch_from IS NULL OR (:p_batch_from IS NOT NULL AND gbh.batch_no >= :p_batch_from)) AND (:p_batch_to IS NULL OR (:p_batch_to IS NOT NULL AND gbh.batch_no <= :p_batch_to)) AND gbh.organization_id = :p_organization_id AND gbh.batch_id = gmd.batch_id AND (:p_product_from IS NULL OR (:p_product_from IS NOT NULL AND msib.concatenated_segments >= :p_product_from)) AND (:p_product_to IS NULL OR (:p_product_to IS NOT NULL AND msib.concatenated_segments <= :p_product_to)) AND msib.organization_id = :p_organization_id AND (:p_batch_status IS NULL OR (:p_batch_status IS NOT NULL AND gbh.batch_status = :p_batch_status)) AND gbh.batch_id = we.wip_entity_id AND we.primary_item_id = gmd.inventory_item_id AND msib.inventory_item_id = gmd.inventory_item_id AND msib.organization_id = gbh.organization_id AND gmd.line_type = 1 AND gl.lookup_type = 'GME_BATCH_STATUS' AND gbh.batch_status = gl.lookup_code AND (NVL(:p_open_po_flag,'N') = 'N' OR (:p_open_po_flag = 'Y' AND EXISTS ( SELECT 'PO/REQ Linked' FROM po_releases_all pr, po_headers_all ph, po_distributions_all pd, po_line_locations_all pll WHERE pd.po_line_id IS NOT NULL AND pd.line_location_id IS NOT NULL AND pd.wip_entity_id = gbh.batch_id AND pd.destination_organization_id = gbh.organization_id AND ph.po_header_id = pd.po_header_id AND pll.line_location_id = pd.line_location_id AND pr.po_release_id (+) = pd.po_release_id AND (pll.cancel_flag IS NULL OR pll.cancel_flag = 'N') AND (pll.quantity_received < (pll.quantity-pll.quantity_cancelled)) AND nvl(pll.closed_code,'OPEN') <> 'FINALLY CLOSED' UNION ALL SELECT 'PO/REQ Linked' FROM po_requisition_lines_all prl WHERE prl.wip_entity_id = gbh.batch_id AND prl.destination_organization_id = gbh.organization_id AND nvl(prl.cancel_flag, 'N') = 'N' AND prl.line_location_id IS NULL UNION ALL SELECT 'PO/REQ Linked' FROM po_requisitions_interface_all pri WHERE pri.wip_entity_id = gbh.batch_id AND pri.destination_organization_id = gbh.organization_id))) ORDER BY gbh.batch_id GME GMEOSP AR GME تقرير المعالجة الخارجية في OPM (بتنسيق XML)(1) Imported from BI Publisher Application: تنفيذ عمليات التصنيع التشغيلي Source: تقرير المعالجة الخارجية في OPM (بتنسيق XML)(1) Short Name: GMEOSP DB package: D GME OPM - Fremdbearbeitung(1) Imported from BI Publisher Description: Auswertung "OPM - Fremdbearbeitung" (XML)(1) Application: Process Manufacturing Prozessfertigung Source: OPM - Fremdbearbeitung (XML)(1) Short Name: GMEOSP DB package: E GME Procesamiento Externo de OPM(1) Imported from BI Publisher Application: Process Manufacturing Process Execution Source: Procesamiento Externo de OPM (XML)(1) Short Name: GMEOSP DB package: F GME Etat Sous-traitance OPM(1) Imported from BI Publisher Application: Process Manufacturing Process Execution Source: Etat Sous-traitance OPM (XML)(1) Short Name: GMEOSP DB package: I GME Rapporto Lavorazione presso terzi OPM(1) Imported from BI Publisher Application: Process Manufacturing Process Execution Source: Rapporto Lavorazione presso terzi OPM (XML)(1) Short Name: GMEOSP DB package: JA GME OPM外注加工レポート(1) Imported from BI Publisher Application: Process Manufacturing Process Execution Source: OPM外注加工レポート(XML)(1) Short Name: GMEOSP DB package: KO GME OPM 외주가공 보고서(1) Imported from BI Publisher Application: Process Manufacturing Process Execution Source: OPM 외주가공 보고서(XML)(1) Short Name: GMEOSP DB package: PTB GME Relatório de Processamento Externo do OPM(1) Imported from BI Publisher Application: Process Manufacturing Process Execution Source: Relatório de Processamento Externo do OPM (XML)(1) Short Name: GMEOSP DB package: RU GME Отчет об обработке на стороне в УНП(1) Imported from BI Publisher Application: Реализация производственного процесса УНП Source: Отчет об обработке на стороне в УНП (XML)(1) Short Name: GMEOSP DB package: S GME Legotillverkning - rapport(1) Imported from BI Publisher Application: Process Manufacturing Process Execution Source: OPM: Legotillverkning - rapport (XML)(1) Short Name: GMEOSP DB package: TR GME OPM Fason Üretim Raporu Imported from BI Publisher Description: OPM Fason Üretim Raporu(XML) Application: Üretim Prosesi Proses Yürütme Yönetimi Source: OPM Fason Üretim Raporu (XML) Short Name: GMEOSP DB package: US GME OPM Outside Processing Imported from BI Publisher Description: OPM Outside Processing Report(XML) Application: Process Manufacturing Process Execution Source: OPM Outside Processing Report (XML) Short Name: GMEOSP DB package: ZHS GME OPM 外协加工报表(1) Imported from BI Publisher Application: OPM 流程执行管理系统 Source: OPM 外协加工报表 (XML)(1) Short Name: GMEOSP DB package: BI Publisher :p_batch_from :p_batch_status :p_batch_to :p_open_po_flag :p_organization_id :p_product_from :p_product_to 1 -10 :p_organization_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR معرف التنظيم معرف التنظيم D Organisationskennung Organisationskennung E Id Organización Id Organización F ID organisation ID organisation I Id organizzazione Id organizzazione JA 組織ID 組織ID KO 조직 ID 조직 ID PTB ID da Organização ID da Organização RU Идент. организации Идент. организации S Organisations-id Organisations-id TR Organizasyon No Organizasyon No US Organization ID Organization ID ZHS 组织标识 组织标识 2 10 :p_batch_from Char AR المجموعة من المجموعة من D Von Produktionsauftrag Von Produktionsauftrag E De Lote De Lote F Batch - De Batch - De I Batch - Da Batch - Da JA バッチ:自 バッチ:自 KO 배치 From 배치 From PTB Ordem de Produção - De Ordem de Produção - De RU Задание с Задание с S Batch från Batch från TR İş Emri - İlk İş Emri - İlk US Batch From Batch From ZHS 批自 批自 3 20 :p_batch_to Char AR المجموعة إلى المجموعة إلى D Bis Produktionsauftrag Bis Produktionsauftrag E A Lote A Lote F Batch - A Batch - A I Batch - A Batch - A JA バッチ:至 バッチ:至 KO 배치 To 배치 To PTB Ordem de Produção - Até Ordem de Produção - Até RU Задание по Задание по S Batch till Batch till TR İş Emri - Son İş Emri - Son US Batch To Batch To ZHS 批至 批至 4 30 :p_product_from Char AR المنتج من المنتج من D Von Produkt Von Produkt E De Producto De Producto F Produit - De Produit - De I Prodotto - Da Prodotto - Da JA 製品:自 製品:自 KO 제품 From 제품 From PTB Produto - De Produto - De RU Продукт с Продукт с S Produkt från Produkt från TR Ürün - İlk Ürün - İlk US Product From Product From ZHS 产品自 产品自 5 40 :p_product_to Char AR المنتج إلى المنتج إلى D Bis Produkt Bis Produkt E A Producto A Producto F Produit - A Produit - A I Prodotto - A Prodotto - A JA 製品:至 製品:至 KO 제품 To 제품 To PTB Produto - Até Produto - Até RU Продукт по Продукт по S Produkt till Produkt till TR Ürün - Son Ürün - Son US Product To Product To ZHS 产品至 产品至 6 50 :p_batch_status LOV Oracle GME_BATCH_STATUSES Y select lookup_code id, lookup_code value, meaning description from gem_lookup_values where lookup_type='GME_BATCH_STATUS' order by lookup_code AR الموقف الموقف E Estado Estado F Statut Statut I Stato Stato JA ステータス ステータス KO 상태 상태 RU Статус Статус TR Statü Statü US Status Status ZHS 状态 状态 7 60 :p_open_po_flag LOV Oracle GME_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description Y AR أوامر الشراء المفتوحة فقط أوامر الشراء المفتوحة فقط D Nur offene Bestellungen Nur offene Bestellungen E Solo Pedidos de Compra Abiertos Solo Pedidos de Compra Abiertos F Commandes en cours seulement Commandes en cours seulement I Solo OA aperti Solo OA aperti JA オープン発注のみ オープン発注のみ KO 개설 PO만 개설 PO만 PTB Somente OCs Abertas Somente OCs Abertas RU Только открытые ЗП Только открытые ЗП S Endast öppna inköpsorder Endast öppna inköpsorder TR Sadece Açık SS'ler Sadece Açık SS'ler US Open POs Only Open POs Only ZHS 仅未结 PO 仅未结 PO