ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 53860F993F6A7167E0630100007F1025 OPM Batch Number Y Y select distinct gbh.batch_no value, null description from gme_batch_header gbh, mtl_parameters mp where gbh.organization_id=mp.organization_id and (xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' or (:$flex$.organization_code is null and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id))) order by gbh.batch_no US Process-manufacturing batch numbers in the selected (or accessible) organizations 53860F993F6B7167E0630100007F1025 OPM Batch Status Y select to_char(flv.lookup_code) id, flv.meaning value, null description from fnd_lookup_values_vl flv where flv.lookup_type='GME_BATCH_STATUS' order by flv.lookup_code US OPM batch status (Pending, WIP, Completed, Closed, Cancelled) 53860F993F697167E0630100007F1025 OPM Item Number Y Y select distinct msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id=mp.organization_id and mp.process_enabled_flag='Y' and (xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' or (:$flex$.organization_code is null and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id))) order by msiv.concatenated_segments US Process-manufacturing-enabled items in the selected (or accessible) organizations 53860F993F687167E0630100007F1025 OPM Organization Code Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood, mtl_parameters mp where ood.organization_id=mp.organization_id and mp.process_enabled_flag='Y' and mp.organization_id<>mp.master_organization_id and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code US Process-manufacturing-enabled inventory organizations the responsibility can access (org_access_view secured) 53840B0694CD768DE0630100007FF85B select ood.organization_code, gbh.batch_no, grv.recipe_no, grv.recipe_version, xxen_util.meaning(to_char(gbh.batch_status),'GME_BATCH_STATUS',553) batch_status, gbh.actual_start_date, gbh.actual_cmplt_date, decode(gmd.line_type,1,'Product',2,'By-Product') output_type, msiv.concatenated_segments product_item, msiv.description product_description, gmd.plan_qty planned_qty, gmd.actual_qty actual_qty, gmd.dtl_um uom, gmd.actual_qty-gmd.plan_qty qty_variance, round((gmd.actual_qty-gmd.plan_qty)/nullif(gmd.plan_qty,0)*100,2) qty_variance_pct, i.planned_input_qty, i.actual_input_qty, round(gmd.plan_qty/nullif(i.planned_input_qty,0)*100,2) planned_yield_pct, round(gmd.actual_qty/nullif(i.actual_input_qty,0)*100,2) actual_yield_pct from gme_batch_header gbh, gme_material_details gmd, mtl_system_items_vl msiv, org_organization_definitions ood, gmd_recipe_validity_rules grvr, gmd_recipes_vl grv, ( select gmd2.batch_id, sum(case when gmd2.line_type=-1 then gmd2.plan_qty end) planned_input_qty, sum(case when gmd2.line_type=-1 then gmd2.actual_qty end) actual_input_qty from gme_material_details gmd2 group by gmd2.batch_id ) i where 1=1 and gbh.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and gbh.batch_id=gmd.batch_id and gmd.line_type in (1,2) and gmd.inventory_item_id=msiv.inventory_item_id and gmd.organization_id=msiv.organization_id and gbh.organization_id=ood.organization_id and gbh.batch_id=i.batch_id and gbh.recipe_validity_rule_id=grvr.recipe_validity_rule_id(+) and grvr.recipe_id=grv.recipe_id(+) order by ood.organization_code, gbh.batch_no, msiv.concatenated_segments OPM Process Execution batch yield variance: planned vs actual product/by-product output and total input per batch, with quantity variance, variance % and planned/actual yield %. org_access_view inventory-org security; optional Organization Code / Batch Number / Product Item / Batch Status / Actual Completion Date parameters. Y US OPM Batch Yield Variance Oracle Process Manufacturing (OPM) batch yield variance: compares planned versus actual product and by-product output quantities against total batch input, reporting quantity variance, variance percentage and planned/actual yield percentage - the key production yield KPI for completed batches. Enginatics 1=1 1 10 1=1 ood.organization_code=:p_org_code LOV OPM Organization Code 53860F993F687167E0630100007F1025 Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood, mtl_parameters mp where ood.organization_id=mp.organization_id and mp.process_enabled_flag='Y' and mp.organization_id<>mp.master_organization_id and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code US Organization Code 2 20 1=1 gbh.batch_no=:p_batch_no LOV OPM Batch Number 53860F993F6A7167E0630100007F1025 Y Y select distinct gbh.batch_no value, null description from gme_batch_header gbh, mtl_parameters mp where gbh.organization_id=mp.organization_id and (xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' or (:$flex$.organization_code is null and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id))) order by gbh.batch_no US Batch Number 3 30 1=1 msiv.concatenated_segments=:p_item LOV OPM Item Number 53860F993F697167E0630100007F1025 Y Y select distinct msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id=mp.organization_id and mp.process_enabled_flag='Y' and (xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' or (:$flex$.organization_code is null and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id))) order by msiv.concatenated_segments US Product Item 4 40 1=1 gbh.batch_status=:p_batch_status LOV OPM Batch Status 53860F993F6B7167E0630100007F1025 Y select to_char(flv.lookup_code) id, flv.meaning value, null description from fnd_lookup_values_vl flv where flv.lookup_type='GME_BATCH_STATUS' order by flv.lookup_code US Batch Status 5 50 1=1 gbh.actual_cmplt_date>=:p_date_from Date US Actual Completion Date From 6 60 1=1 gbh.actual_cmplt_date<:p_date_to+1 Date last_day(:$flex$.actual_completion_date_from) US Actual Completion Date To :$flex$.actual_completion_date_from Actual Completion Date From Y Actual Completion Date To :$flex$.organization_code Organization Code Batch Number :$flex$.organization_code Organization Code Product Item