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 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) 538574176DFA43FFE0630100007FB7A7 select ood.organization_code, gbh.batch_no, gbs.batchstep_no, xxen_util.meaning(to_char(gbs.step_status),'GME_STEP_STATUS',553) step_status, gbs.plan_step_qty, gbs.actual_step_qty, gbsr.resources resource_code, gbsr.plan_rsrc_usage, gbsr.actual_rsrc_usage, round(gbsr.actual_rsrc_usage-gbsr.plan_rsrc_usage,6) usage_variance, gbsr.usage_um, gbsr.plan_rsrc_count, gbsr.actual_rsrc_count, gbs.plan_start_date, gbs.actual_start_date, gbs.plan_cmplt_date, gbs.actual_cmplt_date from gme_batch_steps gbs, gme_batch_step_resources gbsr, gme_batch_header gbh, org_organization_definitions ood 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 gbs.batch_id=gbh.batch_id and gbs.batchstep_id=gbsr.batchstep_id(+) and gbh.organization_id=ood.organization_id order by ood.organization_code, gbh.batch_no, gbs.batchstep_no, gbsr.resources OPM Process Execution batch steps and resource usage: each batch routing step with step status, plan/actual step quantity and dates, and per-resource planned versus actual usage, usage variance, resource count and UOM - for batch execution and resource-efficiency analysis. org_access_view inventory-org security; optional Organization Code / Batch Number / Resource / Step Status parameters. Y US OPM Batch Steps and Resource Usage Oracle Process Manufacturing (OPM) batch steps and resource usage: each production batch routing step with its status, planned versus actual step quantity and dates, and the planned versus actual usage, usage variance, count and UOM of each resource (machine / labor) on the step. Supports batch execution review and resource-efficiency analysis. 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 gbsr.resources=:p_resource LOV custom Y select distinct crd.resources value, null description from cr_rsrc_dtl crd, mtl_parameters mp where crd.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 crd.resources US Resource 4 40 1=1 gbs.step_status=:p_step_status LOV custom Y select to_char(flv.lookup_code) id, flv.meaning value, null description from fnd_lookup_values_vl flv where flv.lookup_type='GME_STEP_STATUS' order by flv.lookup_code US Step Status :$flex$.organization_code Organization Code Batch Number :$flex$.organization_code Organization Code Resource