ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FAD51A9E05362FB09050512Y select h.batch_id, d.material_detail_id line_id, h.formula_id, h.batch_no, d.inventory_item_id ditemid, d.revision, h.wip_whse_code HWIP, h.recipe_validity_rule_id, fd.qty pqty, d.actual_qty aqty, d.dtl_um md_batchum, fd.detail_uom md_formum, rcp.recipe_no, rcp.recipe_version, im.concatenated_segments item_no, im.description item_desc1, im.primary_uom_code itemum, d.inventory_item_id item_id, h.actual_cmplt_date actual_cmplt_date, fd.formulaline_id, GME_GMEBCHYV_XMLP_PKG.cf_formula_qty(h.recipe_validity_rule_id, h.batch_id) CF_formula_qty, GME_GMEBCHYV_XMLP_PKG.cf_delete_transformula() CF_delete_trans, GME_GMEBCHYV_XMLP_PKG.batchum_p batchum, GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id) CF_plan_qty_itemum, GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(d.dtl_um, fd.detail_uom, d.actual_qty, d.inventory_item_id) CF_actual_qty_um, GME_GMEBCHYV_XMLP_PKG.cf_uomformula(fd.detail_uom, d.dtl_um) CF_UOM, GME_GMEBCHYV_XMLP_PKG.cf_acctng_cost1formula(d.inventory_item_id, h.actual_cmplt_date, GME_GMEBCHYV_XMLP_PKG.cf_uomformula(fd.detail_uom, d.dtl_um), im.primary_uom_code, GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id)) CF_acctng_cost1, GME_GMEBCHYV_XMLP_PKG.cf_acctg_cost2formula(GME_GMEBCHYV_XMLP_PKG.cf_uomformula(fd.detail_uom, d.dtl_um), im.primary_uom_code, d.inventory_item_id, GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(d.dtl_um, fd.detail_uom, d.actual_qty, d.inventory_item_id)) CF_acctg_cost2, GME_GMEBCHYV_XMLP_PKG.cf_quantity_variance(GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(d.dtl_um, fd.detail_uom, d.actual_qty, d.inventory_item_id), GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id)) CF_quantity_variance, GME_GMEBCHYV_XMLP_PKG.cf_value_variance(GME_GMEBCHYV_XMLP_PKG.cf_acctg_cost2formula(GME_GMEBCHYV_XMLP_PKG.cf_uomformula(fd.detail_uom, d.dtl_um), im.primary_uom_code, d.inventory_item_id, GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(d.dtl_um, fd.detail_uom, d.actual_qty, d.inventory_item_id)), GME_GMEBCHYV_XMLP_PKG.cf_acctng_cost1formula(d.inventory_item_id, h.actual_cmplt_date, GME_GMEBCHYV_XMLP_PKG.cf_uomformula(fd.detail_uom, d.dtl_um), im.primary_uom_code, GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id))) CF_value_variance, GME_GMEBCHYV_XMLP_PKG.cf_variance_pct(GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id), GME_GMEBCHYV_XMLP_PKG.cf_quantity_variance(GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(d.dtl_um, fd.detail_uom, d.actual_qty, d.inventory_item_id), GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id))) CF_variance_pct, GME_GMEBCHYV_XMLP_PKG.CP_item_cost_p CP_item_cost from gme_batch_header h, gme_material_details d, fm_form_mst f, fm_matl_dtl fd, gmd_recipe_validity_rules val, gmd_recipes rcp, mtl_system_items_kfv im where d.batch_id = h.batch_id and (h.batch_status = 3 or h.batch_status = 4) and d.line_type between 1 and 2 and h.formula_id=f.formula_id and f.formula_id=fd.formula_id and h.recipe_validity_rule_id = val.recipe_validity_rule_id and val.recipe_id = rcp.recipe_id and im.inventory_item_id = d.inventory_item_id and im.organization_id = d.organization_id and d.inventory_item_id=fd.inventory_item_id and d.organization_id = fd.organization_id and d.formulaline_id = fd.formulaline_id and h.organization_id = :P_ORG_ID and ( h.plan_start_date >= :fromdate OR :fromdate IS NULL ) and (h.plan_start_date <= :todate OR :todate IS NULL ) &CP_BatchRange &CP_ItemRange UNION select h.batch_id, d.material_detail_id line_id, h.formula_id, h.batch_no, d.inventory_item_id ditemid, d.revision, h.wip_whse_code HWIP, h.recipe_validity_rule_id, 0 pqty, d.actual_qty aqty, d.dtl_um md_batchum, d.dtl_um md_formum, rcp.recipe_no, rcp.recipe_version, im.concatenated_segments item_no, im.description item_desc1, im.primary_uom_code itemum, d.inventory_item_id item_id, h.actual_cmplt_date actual_cmplt_date, 0 formulaline_id, GME_GMEBCHYV_XMLP_PKG.cf_formula_qty(h.recipe_validity_rule_id, h.batch_id) CF_formula_qty, GME_GMEBCHYV_XMLP_PKG.cf_delete_transformula() CF_delete_trans, GME_GMEBCHYV_XMLP_PKG.batchum_p batchum, GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id) CF_plan_qty_itemum, GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(d.dtl_um, d.dtl_um, d.actual_qty, d.inventory_item_id) CF_actual_qty_um, GME_GMEBCHYV_XMLP_PKG.cf_uomformula(d.dtl_um, d.dtl_um) CF_UOM, GME_GMEBCHYV_XMLP_PKG.cf_acctng_cost1formula(d.inventory_item_id, h.actual_cmplt_date, GME_GMEBCHYV_XMLP_PKG.cf_uomformula(d.dtl_um, d.dtl_um), im.primary_uom_code, GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id)) CF_acctng_cost1, GME_GMEBCHYV_XMLP_PKG.cf_acctg_cost2formula(GME_GMEBCHYV_XMLP_PKG.cf_uomformula(d.dtl_um, d.dtl_um), im.primary_uom_code, d.inventory_item_id, GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(d.dtl_um, d.dtl_um, d.actual_qty, d.inventory_item_id)) CF_acctg_cost2, GME_GMEBCHYV_XMLP_PKG.cf_quantity_variance(GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(d.dtl_um, d.dtl_um, d.actual_qty, d.inventory_item_id), GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id)) CF_quantity_variance, GME_GMEBCHYV_XMLP_PKG.cf_value_variance(GME_GMEBCHYV_XMLP_PKG.cf_acctg_cost2formula(GME_GMEBCHYV_XMLP_PKG.cf_uomformula(d.dtl_um, d.dtl_um), im.primary_uom_code, d.inventory_item_id, GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(d.dtl_um, d.dtl_um, d.actual_qty, d.inventory_item_id)), GME_GMEBCHYV_XMLP_PKG.cf_acctng_cost1formula(d.inventory_item_id, h.actual_cmplt_date, GME_GMEBCHYV_XMLP_PKG.cf_uomformula(d.dtl_um, d.dtl_um), im.primary_uom_code, GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id))) CF_value_variance, GME_GMEBCHYV_XMLP_PKG.cf_variance_pct(GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id), GME_GMEBCHYV_XMLP_PKG.cf_quantity_variance(GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(d.dtl_um, d.dtl_um, d.actual_qty, d.inventory_item_id), GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id))) CF_variance_pct, GME_GMEBCHYV_XMLP_PKG.CP_item_cost_p CP_item_cost from gme_batch_header h, gme_material_details d, fm_form_mst f, gmd_recipe_validity_rules val, gmd_recipes rcp, mtl_system_items_kfv im where d.batch_id = h.batch_id and (h.batch_status = 3 or h.batch_status = 4) and d.line_type between 1 and 2 and h.formula_id=f.formula_id and h.recipe_validity_rule_id = val.recipe_validity_rule_id and val.recipe_id = rcp.recipe_id and im.inventory_item_id = d.inventory_item_id and im.organization_id = d.organization_id and d.formulaline_id IS NULL and h.organization_id = :P_ORG_ID and ( h.plan_start_date >= :fromdate OR :fromdate IS NULL ) and ( h.plan_start_date <= :todate OR :todate IS NULL ) &CP_BatchRange &CP_ItemRange UNION select h.batch_id, fd.formulaline_id, h.formula_id, h.batch_no, fd.inventory_item_id ditemid, fd.revision, h.wip_whse_code HWIP, h.recipe_validity_rule_id, fd.qty pqty, 0 aqty, ' ' md_batchum, fd.detail_uom md_formum, rcp.recipe_no, rcp.recipe_version, im.concatenated_segments item_no, im.description item_desc1, im.primary_uom_code itemum, fd.inventory_item_id item_id, h.actual_cmplt_date actual_cmplt_date, fd.formulaline_id, GME_GMEBCHYV_XMLP_PKG.cf_formula_qty(h.recipe_validity_rule_id, h.batch_id) CF_formula_qty, GME_GMEBCHYV_XMLP_PKG.cf_delete_transformula() CF_delete_trans, GME_GMEBCHYV_XMLP_PKG.batchum_p batchum, GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id) CF_plan_qty_itemum, GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(' ', fd.detail_uom, 0, fd.inventory_item_id) CF_actual_qty_um, GME_GMEBCHYV_XMLP_PKG.cf_uomformula(fd.detail_uom, ' ') CF_UOM, GME_GMEBCHYV_XMLP_PKG.cf_acctng_cost1formula(fd.inventory_item_id, h.actual_cmplt_date, GME_GMEBCHYV_XMLP_PKG.cf_uomformula(fd.detail_uom, ' '), im.primary_uom_code, GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id)) CF_acctng_cost1, GME_GMEBCHYV_XMLP_PKG.cf_acctg_cost2formula(GME_GMEBCHYV_XMLP_PKG.cf_uomformula(fd.detail_uom, ' '), im.primary_uom_code, fd.inventory_item_id, GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(' ', fd.detail_uom, 0, fd.inventory_item_id)) CF_acctg_cost2, GME_GMEBCHYV_XMLP_PKG.cf_quantity_variance(GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(' ', fd.detail_uom, 0, fd.inventory_item_id), GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id)) CF_quantity_variance, GME_GMEBCHYV_XMLP_PKG.cf_value_variance(GME_GMEBCHYV_XMLP_PKG.cf_acctg_cost2formula(GME_GMEBCHYV_XMLP_PKG.cf_uomformula(fd.detail_uom, ' '), im.primary_uom_code, fd.inventory_item_id, GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(' ', fd.detail_uom, 0, fd.inventory_item_id)), GME_GMEBCHYV_XMLP_PKG.cf_acctng_cost1formula(fd.inventory_item_id, h.actual_cmplt_date, GME_GMEBCHYV_XMLP_PKG.cf_uomformula(fd.detail_uom, ' '), im.primary_uom_code, GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id))) CF_value_variance, GME_GMEBCHYV_XMLP_PKG.cf_variance_pct(GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id), GME_GMEBCHYV_XMLP_PKG.cf_quantity_variance(GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(' ', fd.detail_uom, 0, fd.inventory_item_id), GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id))) CF_variance_pct, GME_GMEBCHYV_XMLP_PKG.CP_item_cost_p CP_item_cost from gme_batch_header h, fm_matl_dtl fd, fm_form_mst f, gmd_recipe_validity_rules val, gmd_recipes rcp, mtl_system_items_kfv im where f.formula_id=fd.formula_id and h.recipe_validity_rule_id = val.recipe_validity_rule_id and val.recipe_id = rcp.recipe_id and (h.batch_status = 3 or h.batch_status = 4) and fd.line_type between 1 and 2 and h.formula_id=f.formula_id and im.inventory_item_id = fd.inventory_item_id and im.organization_id = fd.organization_id and fd.formulaline_id NOT IN ( select formulaline_id from gme_material_details where batch_id = h.batch_id and (line_type between 1 and 2) and formulaline_id IS NOT NULL ) and h.organization_id = :P_ORG_ID and ( h.plan_start_date >= :fromdate OR :fromdate IS NULL ) and ( h.plan_start_date <= :todate OR :todate IS NULL ) &CP_BatchRange &CP_ItemRange UNION select h.batch_id, 0 line_id, 0 formula_id, h.batch_no, 0 ditemid, ' ' revision, h.wip_whse_code HWIP, h.recipe_validity_rule_id, 0 pqty, 0 aqty, ' ' md_batchum, ' ' md_formum, null recipe_no, null recipe_version, ' ' item_no, ' ' item_desc1, ' ' itemum, 0 item_id, h.actual_cmplt_date actual_cmplt_date, 0 formulaline_id, GME_GMEBCHYV_XMLP_PKG.cf_formula_qty(h.recipe_validity_rule_id, h.batch_id) CF_formula_qty, GME_GMEBCHYV_XMLP_PKG.cf_delete_transformula() CF_delete_trans, GME_GMEBCHYV_XMLP_PKG.batchum_p batchum, GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(0, h.recipe_validity_rule_id, 0, h.batch_id) CF_plan_qty_itemum, GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(' ', ' ', 0, 0) CF_actual_qty_um, GME_GMEBCHYV_XMLP_PKG.cf_uomformula(' ', ' ') CF_UOM, GME_GMEBCHYV_XMLP_PKG.cf_acctng_cost1formula(0, h.actual_cmplt_date, GME_GMEBCHYV_XMLP_PKG.cf_uomformula(' ', ' '), ' ', GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(0, h.recipe_validity_rule_id, 0, h.batch_id)) CF_acctng_cost1, GME_GMEBCHYV_XMLP_PKG.cf_acctg_cost2formula(GME_GMEBCHYV_XMLP_PKG.cf_uomformula(' ', ' '), ' ', 0, GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(' ', ' ', 0, 0)) CF_acctg_cost2, GME_GMEBCHYV_XMLP_PKG.cf_quantity_variance(GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(' ', ' ', 0, 0), GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(0, h.recipe_validity_rule_id, 0, h.batch_id)) CF_quantity_variance, GME_GMEBCHYV_XMLP_PKG.cf_value_variance(GME_GMEBCHYV_XMLP_PKG.cf_acctg_cost2formula(GME_GMEBCHYV_XMLP_PKG.cf_uomformula(' ', ' '), ' ', 0, GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(' ', ' ', 0, 0)), GME_GMEBCHYV_XMLP_PKG.cf_acctng_cost1formula(0, h.actual_cmplt_date, GME_GMEBCHYV_XMLP_PKG.cf_uomformula(' ', ' '), ' ', GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(0, h.recipe_validity_rule_id, 0, h.batch_id))) CF_value_variance, GME_GMEBCHYV_XMLP_PKG.cf_variance_pct(GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(0, h.recipe_validity_rule_id, 0, h.batch_id), GME_GMEBCHYV_XMLP_PKG.cf_quantity_variance(GME_GMEBCHYV_XMLP_PKG.cf_actual_qty_umformula(' ', ' ', 0, 0), GME_GMEBCHYV_XMLP_PKG.cf_plan_qty_itemumformula(0, h.recipe_validity_rule_id, 0, h.batch_id))) CF_variance_pct, GME_GMEBCHYV_XMLP_PKG.CP_item_cost_p CP_item_cost from gme_batch_header h where (h.batch_status = 3 or h.batch_status = 4) and h.recipe_validity_rule_id IS NULL and h.organization_id = :P_ORG_ID and ( h.plan_start_date >= :fromdate OR :fromdate IS NULL ) and ( h.plan_start_date <= :todate OR :todate IS NULL ) &CP_BatchRange and EXISTS ( SELECT 1 FROM gme_material_details d,mtl_system_items_kfv im WHERE d.batch_id = h.batch_id and d.organization_id = :P_ORG_ID and d.line_type IN (1,2) and d.inventory_item_id = im.inventory_item_id &CP_ItemRange ) ORDER BY 4, 14 GME GMEBCHYV_XML AR GME تباين عائد التشغيلة Imported from BI Publisher Description: تقرير تباين عائد مجموعة OPM Application: تنفيذ عمليات التصنيع التشغيلي Source: تباين عائد التشغيلة (XML) Short Name: GMEBCHYV_XML DB package: GME_GMEBCHYV_XMLP_PKG D GME Produktionsausbeute - Soll-/Istabweichung Imported from BI Publisher Description: Auswertung "Produktionsausbeute - Soll-/Istabweichung" in OPM Application: Process Manufacturing Prozessfertigung Source: Produktionsausbeute - Soll-/Istabweichung (XML) Short Name: GMEBCHYV_XML DB package: GME_GMEBCHYV_XMLP_PKG E GME Desviación del Rendimiento de Lotes Imported from BI Publisher Description: Informe Desviación del Rendimiento de Lotes de OPM Application: Process Manufacturing Process Execution Source: Desviación del Rendimiento de Lotes (XML) Short Name: GMEBCHYV_XML DB package: GME_GMEBCHYV_XMLP_PKG F GME Ecart de production de batch Imported from BI Publisher Description: Etat d'écart de production de batch - OPM Application: Process Manufacturing Process Execution Source: Ecart de production de batch (XML) Short Name: GMEBCHYV_XML DB package: GME_GMEBCHYV_XMLP_PKG I GME Scostamento rendimento batch Imported from BI Publisher Description: Rapporto Scostamento rendimento batch (OPM) Application: Process Manufacturing Process Execution Source: Scostamento rendimento batch (XML) Short Name: GMEBCHYV_XML DB package: GME_GMEBCHYV_XMLP_PKG JA GME バッチ収率差異 Imported from BI Publisher Description: OPMのバッチ収率差異レポート Application: Process Manufacturing Process Execution Source: バッチ収率差異(XML) Short Name: GMEBCHYV_XML DB package: GME_GMEBCHYV_XMLP_PKG KO GME 배치 수율 차이 Imported from BI Publisher Description: OPM 뱃치 수율 차이 보고서 Application: Process Manufacturing Process Execution Source: 배치 수율 차이(XML) Short Name: GMEBCHYV_XML DB package: GME_GMEBCHYV_XMLP_PKG PTB GME Variação do Aproveitamento da ordem de produção Imported from BI Publisher Description: Relatório de Variação de Aproveitamento da Ordem de Produção do OPM Application: Process Manufacturing Process Execution Source: Variação do Aproveitamento da ordem de produção (XML) Short Name: GMEBCHYV_XML DB package: GME_GMEBCHYV_XMLP_PKG RU GME Перепроизводство или недопроизводство заданий Imported from BI Publisher Description: УНП: отчет о перепроизводстве или недопроизводстве заданий Application: Реализация производственного процесса УНП Source: Перепроизводство или недопроизводство заданий (XML) Short Name: GMEBCHYV_XML DB package: GME_GMEBCHYV_XMLP_PKG S GME Utbytesavvikelse i batch Imported from BI Publisher Description: Utbytesavvikelse i batch i OPM - rapport Application: Process Manufacturing Process Execution Source: Utbytesavvikelse i batch (XML) Short Name: GMEBCHYV_XML DB package: GME_GMEBCHYV_XMLP_PKG TR GME İş Emri Verim Farkı Imported from BI Publisher Description: OPM İş Emri Farkı Raporu Application: Üretim Prosesi Proses Yürütme Yönetimi Source: İş Emri Verim Farkı (XML) Short Name: GMEBCHYV_XML DB package: GME_GMEBCHYV_XMLP_PKG US GME Batch Yield Variance Imported from BI Publisher Description: Batch Yield Variance Report of OPM Application: Process Manufacturing Process Execution Source: Batch Yield Variance (XML) Short Name: GMEBCHYV_XML DB package: GME_GMEBCHYV_XMLP_PKG ZHS GME 批产量差异 Imported from BI Publisher Description: OPM 批产量差异报表 Application: OPM 流程执行管理系统 Source: 批产量差异 (XML) Short Name: GMEBCHYV_XML DB package: GME_GMEBCHYV_XMLP_PKG BI Publisher &cp_batchrange &cp_itemrange :batchum :cp_batchrange :cp_daterange :cp_item_cost :cp_itemrange :curr_code :frombatch :fromdate :fromitem :nonblocksql :p_code :p_conc_request_id :p_org_id :tobatch :todate :toitem 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 :fromdate Date AR من تاريخ البداية من تاريخ البداية D Von Startdatum Von Startdatum E De Fecha de Inicio De Fecha de Inicio F Date de début - De Date de début - De I Data inizio - Da Data inizio - Da JA 開始日:自 開始日:自 KO 시작 일자: 부터 시작 일자: 부터 PTB Data Inicial - De Data Inicial - De RU Начальная дата с Начальная дата с S Från startdatum Från startdatum TR İlk Başlangıç Tarihi İlk Başlangıç Tarihi US From Start Date From Start Date ZHS 自起始日期 自起始日期 3 20 :todate Date :$flex$.from_start_date AR إلى تاريخ البداية إلى تاريخ البداية D Bis Startdatum Bis Startdatum E A Fecha de Inicio A Fecha de Inicio F Date de début - A Date de début - A I Data inizio - A Data inizio - A JA 開始日:至 開始日:至 KO 시작 일자: 까지 시작 일자: 까지 PTB Data Inicial - Até Data Inicial - Até RU Начальная дата по Начальная дата по S Till startdatum Till startdatum TR Son Başlangıç Tarihi Son Başlangıç Tarihi US To Start Date To Start Date ZHS 起始日期上限 起始日期上限 4 30 :fromitem LOV Oracle GME_ITEMS Y select concatenated_segments id, concatenated_segments value, description description from mtl_system_items_kfv where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by 1 AR من صنف من صنف D Von Artikel Von Artikel E De Artículo De Artículo F Article - De Article - De I Articolo - Da Articolo - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Item - De Item - De RU Позиция с Позиция с S Från artikel Från artikel TR İlk Kalem İlk Kalem US From Item From Item ZHS 起始物料 起始物料 5 40 :toitem LOV Oracle GME_ITEMS Y select concatenated_segments id, concatenated_segments value, description description from mtl_system_items_kfv where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by 1 :$flex$.from_item AR إلى الصنف إلى الصنف D Bis Artikel Bis Artikel E A Artículo A Artículo F Article - A Article - A I Articolo - A Articolo - A JA 品目:至 品目:至 KO 품목: 까지 품목: 까지 PTB Item - Até Item - Até RU Позиция по Позиция по S Till artikel Till artikel TR Son Kalem Son Kalem US To Item To Item ZHS 终止物料 终止物料 6 50 :frombatch LOV Oracle GME_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 自批 起始批号 7 60 :tobatch LOV Oracle GME_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 至批 终止批号