ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FAE51A9E05362FB09050512Y SELECT h.batch_no, im.concatenated_segments item_no, im.description item_desc1, d.revision, h.batch_id, h.wip_whse_code, h.formula_id , h.actual_cmplt_date, h.recipe_validity_rule_id, rcp.recipe_no, rcp.recipe_version, im.primary_uom_code item_um , d.plan_qty pqty, d.actual_qty aqty, d.dtl_um batchum, d.inventory_item_id ditemid, d.material_detail_id line_id, 'U' var_type, fd.formulaline_id, fd.detail_uom formum, GME_GMEMUSBV_XMLP_PKG.cf_batch_sizeformula(h.recipe_validity_rule_id, h.batch_id) CF_batch_size, GME_GMEMUSBV_XMLP_PKG.cf_itemumformula(h.recipe_validity_rule_id, h.batch_id) CF_itemum, /*GME_GMEMUSBV_XMLP_PKG.cf_total_varianceformula(:CS_tot_U_value_variance, :CS_tot_S_value_variance) CF_total_variance,*/ GME_GMEMUSBV_XMLP_PKG.cf_wipcode() CF_wipcode, GME_GMEMUSBV_XMLP_PKG.cf_delete_transformula() CF_delete_trans, GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id) trans_qty, GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(d.dtl_um, fd.detail_uom, d.actual_qty, d.inventory_item_id) CF_actl_qty_itemum, GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost(d.inventory_item_id, h.actual_cmplt_date) CF_acctg_cost, GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost2formula(GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id)) CF_acctg_cost2, GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(d.dtl_um, fd.detail_uom, d.actual_qty, d.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id)) CF_quantity_variance, GME_GMEMUSBV_XMLP_PKG.cf_value_variance(d.dtl_um, im.primary_uom_code, d.inventory_item_id, GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(d.dtl_um, fd.detail_uom, d.actual_qty, d.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id)), GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost(d.inventory_item_id, h.actual_cmplt_date)) CF_value_variance, GME_GMEMUSBV_XMLP_PKG.cf_u_value_varianceformula(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(d.dtl_um, fd.detail_uom, d.actual_qty, d.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id), GME_GMEMUSBV_XMLP_PKG.cf_value_variance(d.dtl_um, im.primary_uom_code, d.inventory_item_id, GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(d.dtl_um, fd.detail_uom, d.actual_qty, d.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id)), GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost(d.inventory_item_id, h.actual_cmplt_date))) CF_U_value_variance, GME_GMEMUSBV_XMLP_PKG.cf_s_value_varianceformula(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(d.dtl_um, fd.detail_uom, d.actual_qty, d.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id), GME_GMEMUSBV_XMLP_PKG.cf_value_variance(d.dtl_um, im.primary_uom_code, d.inventory_item_id, GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(d.dtl_um, fd.detail_uom, d.actual_qty, d.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id)), GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost(d.inventory_item_id, h.actual_cmplt_date))) CF_S_value_variance, GME_GMEMUSBV_XMLP_PKG.cf_variance_pct(GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id), GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(d.dtl_um, fd.detail_uom, d.actual_qty, d.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id))) CF_variance_pct, GME_GMEMUSBV_XMLP_PKG.cf_uomformula(fd.detail_uom, d.dtl_um) CF_UOM, GME_GMEMUSBV_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 (h.batch_status = 3 or h.batch_status = 4) and h.batch_type = 0 and d.batch_id= h.batch_id and h.recipe_validity_rule_id = val.recipe_validity_rule_id and val.recipe_id = rcp.recipe_id and ( d.line_type = -1 ) and f.formula_id= h.formula_id and f.formula_id= fd.formula_id and im.organization_id = d.organization_id and im.inventory_item_id = d.inventory_item_id and fd.line_type=-1 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_1 &CP_ItemRange_1 UNION SELECT h.batch_no, im.concatenated_segments item_no, im.description item_desc1, d.revision, h.batch_id, h.wip_whse_code, h.formula_id , h.actual_cmplt_date, h.recipe_validity_rule_id, rcp.recipe_no, rcp.recipe_version, im.primary_uom_code , d.plan_qty pqty, d.actual_qty aqty, d.dtl_um batchum, d.inventory_item_id ditemid, d.material_detail_id line_id, 'S' var_type, 0 formulaline_id, d.dtl_um formum, GME_GMEMUSBV_XMLP_PKG.cf_batch_sizeformula(h.recipe_validity_rule_id, h.batch_id) CF_batch_size, GME_GMEMUSBV_XMLP_PKG.cf_itemumformula(h.recipe_validity_rule_id, h.batch_id) CF_itemum, /*GME_GMEMUSBV_XMLP_PKG.cf_total_varianceformula(:CS_tot_U_value_variance, :CS_tot_S_value_variance) CF_total_variance,*/ GME_GMEMUSBV_XMLP_PKG.cf_wipcode() CF_wipcode, GME_GMEMUSBV_XMLP_PKG.cf_delete_transformula() CF_delete_trans, GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id) trans_qty, GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(d.dtl_um, d.dtl_um , d.actual_qty, d.inventory_item_id) CF_actl_qty_itemum, GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost(d.inventory_item_id, h.actual_cmplt_date) CF_acctg_cost, GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost2formula(GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id)) CF_acctg_cost2, GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(d.dtl_um, d.dtl_um , d.actual_qty, d.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id)) CF_quantity_variance, GME_GMEMUSBV_XMLP_PKG.cf_value_variance(d.dtl_um, im.primary_uom_code, d.inventory_item_id, GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(d.dtl_um, d.dtl_um , d.actual_qty, d.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id)), GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost(d.inventory_item_id, h.actual_cmplt_date)) CF_value_variance, GME_GMEMUSBV_XMLP_PKG.cf_u_value_varianceformula(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(d.dtl_um, d.dtl_um , d.actual_qty, d.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id), GME_GMEMUSBV_XMLP_PKG.cf_value_variance(d.dtl_um, im.primary_uom_code, d.inventory_item_id, GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(d.dtl_um, d.dtl_um , d.actual_qty, d.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id)), GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost(d.inventory_item_id, h.actual_cmplt_date))) CF_U_value_variance, GME_GMEMUSBV_XMLP_PKG.cf_s_value_varianceformula(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(d.dtl_um, d.dtl_um , d.actual_qty, d.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id), GME_GMEMUSBV_XMLP_PKG.cf_value_variance(d.dtl_um, im.primary_uom_code, d.inventory_item_id, GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(d.dtl_um, d.dtl_um , d.actual_qty, d.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id)), GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost(d.inventory_item_id, h.actual_cmplt_date))) CF_S_value_variance, GME_GMEMUSBV_XMLP_PKG.cf_variance_pct(GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id), GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(d.dtl_um, d.dtl_um , d.actual_qty, d.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id))) CF_variance_pct, GME_GMEMUSBV_XMLP_PKG.cf_uomformula(d.dtl_um, d.dtl_um) CF_UOM, GME_GMEMUSBV_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 (h.batch_status = 3 or h.batch_status = 4) and h.batch_type = 0 and h.recipe_validity_rule_id = val.recipe_validity_rule_id and val.recipe_id = rcp.recipe_id and d.batch_id= h.batch_id and ( d.line_type = -1 ) and f.formula_id= h.formula_id and im.organization_id = d.organization_id and im.inventory_item_id = d.inventory_item_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_1 &CP_ItemRange_1 UNION SELECT h.batch_no, im.concatenated_segments item_no, im.description item_desc1, fd.revision, h.batch_id, h.wip_whse_code, h.formula_id , h.actual_cmplt_date, h.recipe_validity_rule_id, rcp.recipe_no, rcp.recipe_version, im.primary_uom_code item_um , 0 pqty, 0 aqty, fd.detail_uom batchum, fd.inventory_item_id ditemid, 0 line_id, 'S' var_type, fd.formulaline_id, fd.detail_uom formum, GME_GMEMUSBV_XMLP_PKG.cf_batch_sizeformula(h.recipe_validity_rule_id, h.batch_id) CF_batch_size, GME_GMEMUSBV_XMLP_PKG.cf_itemumformula(h.recipe_validity_rule_id, h.batch_id) CF_itemum, /*GME_GMEMUSBV_XMLP_PKG.cf_total_varianceformula(:CS_tot_U_value_variance, :CS_tot_S_value_variance) CF_total_variance,*/ GME_GMEMUSBV_XMLP_PKG.cf_wipcode() CF_wipcode, GME_GMEMUSBV_XMLP_PKG.cf_delete_transformula() CF_delete_trans, GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id) trans_qty, GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(fd.detail_uom, fd.detail_uom, 0, fd.inventory_item_id) CF_actl_qty_itemum, GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost(fd.inventory_item_id, h.actual_cmplt_date) CF_acctg_cost, GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost2formula(GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id)) CF_acctg_cost2, GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(fd.detail_uom, fd.detail_uom, 0, fd.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id)) CF_quantity_variance, GME_GMEMUSBV_XMLP_PKG.cf_value_variance(fd.detail_uom, im.primary_uom_code, fd.inventory_item_id, GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(fd.detail_uom, fd.detail_uom, 0, fd.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id)), GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost(fd.inventory_item_id, h.actual_cmplt_date)) CF_value_variance, GME_GMEMUSBV_XMLP_PKG.cf_u_value_varianceformula(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(fd.detail_uom, fd.detail_uom, 0, fd.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id), GME_GMEMUSBV_XMLP_PKG.cf_value_variance(fd.detail_uom, im.primary_uom_code, fd.inventory_item_id, GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(fd.detail_uom, fd.detail_uom, 0, fd.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id)), GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost(fd.inventory_item_id, h.actual_cmplt_date))) CF_U_value_variance, GME_GMEMUSBV_XMLP_PKG.cf_s_value_varianceformula(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(fd.detail_uom, fd.detail_uom, 0, fd.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id), GME_GMEMUSBV_XMLP_PKG.cf_value_variance(fd.detail_uom, im.primary_uom_code, fd.inventory_item_id, GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(fd.detail_uom, fd.detail_uom, 0, fd.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id)), GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost(fd.inventory_item_id, h.actual_cmplt_date))) CF_S_value_variance, GME_GMEMUSBV_XMLP_PKG.cf_variance_pct(GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id), GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula(fd.detail_uom, fd.detail_uom, 0, fd.inventory_item_id), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(fd.formulaline_id, h.recipe_validity_rule_id, h.formula_id, h.batch_id))) CF_variance_pct, GME_GMEMUSBV_XMLP_PKG.cf_uomformula(fd.detail_uom, fd.detail_uom) CF_UOM, GME_GMEMUSBV_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 (h.batch_status = 3 or h.batch_status = 4) and h.batch_type = 0 and h.recipe_validity_rule_id = val.recipe_validity_rule_id and val.recipe_id = rcp.recipe_id and f.formula_id= fd.formula_id and ( fd.line_type = -1 ) and f.formula_id(+)= h.formula_id and im.organization_id = fd.organization_id and im.inventory_item_id = fd.inventory_item_id and fd.formulaline_id NOT IN ( select formulaline_id from gme_material_details where batch_id = h.batch_id and line_type = -1 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_1 &CP_ItemRange_1 UNION SELECT h.batch_no, '0' item_no, '0' item_desc1, '' revision, h.batch_id, h.wip_whse_code, h.formula_id , h.actual_cmplt_date, h.recipe_validity_rule_id, null recipe_no, null recipe_version, '0' item_um , 0 pqty, 0 aqty, '0' batchum, 0 ditemid, 0 line_id, 'L' var_type, 0 formulaline_id, '0' formum, GME_GMEMUSBV_XMLP_PKG.cf_batch_sizeformula(h.recipe_validity_rule_id, h.batch_id) CF_batch_size, GME_GMEMUSBV_XMLP_PKG.cf_itemumformula(h.recipe_validity_rule_id, h.batch_id) CF_itemum, /*GME_GMEMUSBV_XMLP_PKG.cf_total_varianceformula(:CS_tot_U_value_variance, :CS_tot_S_value_variance) CF_total_variance,*/ GME_GMEMUSBV_XMLP_PKG.cf_wipcode() CF_wipcode, GME_GMEMUSBV_XMLP_PKG.cf_delete_transformula() CF_delete_trans, GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id) trans_qty, GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula('0', '0', 0, 0) CF_actl_qty_itemum, GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost(0, h.actual_cmplt_date) CF_acctg_cost, GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost2formula(GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id)) CF_acctg_cost2, GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula('0', '0', 0, 0), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id)) CF_quantity_variance, GME_GMEMUSBV_XMLP_PKG.cf_value_variance('0', '0', 0, GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula('0', '0', 0, 0), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id)), GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost(0, h.actual_cmplt_date)) CF_value_variance, GME_GMEMUSBV_XMLP_PKG.cf_u_value_varianceformula(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula('0', '0', 0, 0), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id), GME_GMEMUSBV_XMLP_PKG.cf_value_variance('0', '0', 0, GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula('0', '0', 0, 0), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id)), GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost(0, h.actual_cmplt_date))) CF_U_value_variance, GME_GMEMUSBV_XMLP_PKG.cf_s_value_varianceformula(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula('0', '0', 0, 0), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id), GME_GMEMUSBV_XMLP_PKG.cf_value_variance('0', '0', 0, GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula('0', '0', 0, 0), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id)), GME_GMEMUSBV_XMLP_PKG.cf_acctg_cost(0, h.actual_cmplt_date))) CF_S_value_variance, GME_GMEMUSBV_XMLP_PKG.cf_variance_pct(GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id), GME_GMEMUSBV_XMLP_PKG.cf_quantity_variance(GME_GMEMUSBV_XMLP_PKG.cf_actl_qty_itemumformula('0', '0', 0, 0), GME_GMEMUSBV_XMLP_PKG.trans_qtyformula_005(0, h.recipe_validity_rule_id, h.formula_id, h.batch_id))) CF_variance_pct, GME_GMEMUSBV_XMLP_PKG.cf_uomformula('0', '0') CF_UOM, GME_GMEMUSBV_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.batch_type = 0 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_1 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 = -1 and d.inventory_item_id = im.inventory_item_id &CP_ItemRange_1 ) ORDER BY 1,2 GME GMEMUSBV_XML AR GME استخدام المواد وتباين البدائل Imported from BI Publisher Description: تقرير استخدام المواد وتباين البدائل في OPM Application: تنفيذ عمليات التصنيع التشغيلي Source: استخدام المواد وتباين البدائل (XML) Short Name: GMEMUSBV_XML DB package: GME_GMEMUSBV_XMLP_PKG D GME Materialverbrauch/Materialsubstitution - Soll-/Istabweichung Imported from BI Publisher Description: Auswertung "Materialverbrauch/Materialsubstitution - Soll-/Istabweichung" in OPM Application: Process Manufacturing Prozessfertigung Source: Materialverbrauch/Materialsubstitution - Soll-/Istabweichung (XML) Short Name: GMEMUSBV_XML DB package: GME_GMEMUSBV_XMLP_PKG E GME Desviación de Uso y Sustitución de Materiales Imported from BI Publisher Description: Informe Desviación de Uso y Sustitución de Materiales de OPM Application: Process Manufacturing Process Execution Source: Desviación de Uso y Sustitución de Materiales (XML) Short Name: GMEMUSBV_XML DB package: GME_GMEMUSBV_XMLP_PKG F GME Ecarts d'utilisation des matières et de substitution Imported from BI Publisher Description: Etat Ecarts d'utilisation des matières et de substitution - OPM Application: Process Manufacturing Process Execution Source: Ecarts d'utilisation des matières et de substitution (XML) Short Name: GMEMUSBV_XML DB package: GME_GMEMUSBV_XMLP_PKG I GME Uso materiali e scostamento sostituzioni Imported from BI Publisher Description: Rapporto Uso materiali e scostamento sostituzioni (OPM) Application: Process Manufacturing Process Execution Source: Uso materiali e scostamento sostituzioni (XML) Short Name: GMEMUSBV_XML DB package: GME_GMEMUSBV_XMLP_PKG JA GME 原材料使用量および代替品差異 Imported from BI Publisher Description: OPMの原材料使用量および代替品差異レポート Application: Process Manufacturing Process Execution Source: 原材料使用量および代替品差異(XML) Short Name: GMEMUSBV_XML DB package: GME_GMEMUSBV_XMLP_PKG KO GME 자재 사용 및 대체 차이 Imported from BI Publisher Description: OPM 자재 사용량 및 대체 자재 차이 보고서 Application: Process Manufacturing Process Execution Source: 자재 사용 및 대체 차이(XML) Short Name: GMEMUSBV_XML DB package: GME_GMEMUSBV_XMLP_PKG PTB GME Uso de Material e de Variação de Substituição Imported from BI Publisher Description: Relatório de Uso de Material e de Variação de Substituição do OPM Application: Process Manufacturing Process Execution Source: Uso de Material e de Variação de Substituição (XML) Short Name: GMEMUSBV_XML DB package: GME_GMEMUSBV_XMLP_PKG RU GME Расхождение в расходе материала и заменяющих компонентов Imported from BI Publisher Description: УНП: отчет о расхождениях в расходе материала и заменяющих компонентов Application: Реализация производственного процесса УНП Source: Расхождение в расходе материала и заменяющих компонентов (XML) Short Name: GMEMUSBV_XML DB package: GME_GMEMUSBV_XMLP_PKG S GME Materialåtgång och ersättningsavvikelse Imported from BI Publisher Description: Materialåtgång och ersättningsavvikelse - rapport i OPM Application: Process Manufacturing Process Execution Source: Materialåtgång och ersättningsavvikelse (XML) Short Name: GMEMUSBV_XML DB package: GME_GMEMUSBV_XMLP_PKG TR GME Malzeme Kullanımı ve Eşdeğer Malzeme Farkı Imported from BI Publisher Description: OPM Malzeme Kullanımı ve Eşdeğer Malzeme Farkı Raporu Application: Üretim Prosesi Proses Yürütme Yönetimi Source: Malzeme Kullanımı ve Eşdeğer Malzeme Farkı (XML) Short Name: GMEMUSBV_XML DB package: GME_GMEMUSBV_XMLP_PKG US GME Material Usage and Substitution Variance Imported from BI Publisher Description: Material Usage and Substitution Variance Report of OPM Application: Process Manufacturing Process Execution Source: Material Usage and Substitution Variance (XML) Short Name: GMEMUSBV_XML DB package: GME_GMEMUSBV_XMLP_PKG ZHS GME 物料用量和替代差异 Imported from BI Publisher Description: OPM 物料用量和替代差异报表 Application: OPM 流程执行管理系统 Source: 物料用量和替代差异 (XML) Short Name: GMEMUSBV_XML DB package: GME_GMEMUSBV_XMLP_PKG BI Publisher &cp_batchrange_1 &cp_itemrange_1 :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 至批 终止批号