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) 53840B0694D0768DE0630100007FF85B select ood.organization_code, gbh.batch_no, xxen_util.meaning(to_char(gbh.batch_status),'GME_BATCH_STATUS',553) batch_status, gbh.actual_cmplt_date, msiv.concatenated_segments item, msiv.description item_description, gmd.plan_qty, gmd.actual_qty, gmd.dtl_um uom, gmd.actual_qty-gmd.plan_qty usage_variance, round((gmd.actual_qty-gmd.plan_qty)/nullif(gmd.plan_qty,0)*100,2) usage_variance_pct, gmd.plan_qty-gmd.actual_qty remaining_qty, gmd.scrap_factor, gmd.original_qty, xxen_util.yes(case when gmd.original_qty is not null and gmd.original_qty<>gmd.plan_qty then 'Y' end) substitution from gme_material_details gmd, gme_batch_header gbh, mtl_system_items_vl msiv, org_organization_definitions ood where 1=1 and gmd.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 gmd.batch_id=gbh.batch_id and gmd.line_type=-1 and gmd.inventory_item_id=msiv.inventory_item_id and gmd.organization_id=msiv.organization_id and gmd.organization_id=ood.organization_id order by ood.organization_code, gbh.batch_no, msiv.concatenated_segments OPM Process Execution batch material usage and substitution variance: per-ingredient planned versus actual consumption with usage variance, variance %, remaining quantity, scrap factor and a substitution indicator (original versus planned quantity). org_access_view inventory-org security; optional Organization Code / Batch Number / Ingredient Item / Batch Status / Actual Completion Date / Show only variances parameters. Y US OPM Batch Material Usage and Substitution Variance Oracle Process Manufacturing (OPM) batch material usage and substitution variance: per-ingredient planned versus actual consumption per production batch, with usage variance, variance percentage, remaining quantity, scrap factor and a substitution indicator. Exposes over/under-consumption and material substitutions at the batch line level. 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 Ingredient 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 7 70 1=1 gmd.actual_qty<>gmd.plan_qty LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show only variances :$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 Ingredient Item