ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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) 538574176DFC43FFE0630100007FB7A7Y select ood.organization_code, msiv.concatenated_segments item, msiv.description, msiv.inventory_item_status_code item_status, msiv.primary_uom_code uom, xxen_util.yes(msiv.recipe_enabled_flag) recipe_enabled, xxen_util.yes(msiv.process_execution_enabled_flag) process_execution_enabled, xxen_util.yes(msiv.process_quality_enabled_flag) process_quality_enabled, xxen_util.yes(msiv.process_costing_enabled_flag) process_costing_enabled, xxen_util.yes(msiv.grade_control_flag) grade_controlled, msiv.default_grade, decode(msiv.lot_control_code,1,'No lot control',2,'Lot controlled') lot_control, xxen_util.yes(msiv.child_lot_flag) child_lot_enabled, xxen_util.yes(msiv.lot_divisible_flag) lot_divisible, decode(msiv.shelf_life_code,1,'No shelf life control',2,'Shelf life days',4,'User-defined expiration') shelf_life_control, msiv.shelf_life_days from mtl_system_items_vl msiv, org_organization_definitions ood where 1=1 and msiv.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 msiv.organization_id=ood.organization_id and (msiv.recipe_enabled_flag='Y' or msiv.process_execution_enabled_flag='Y' or msiv.process_quality_enabled_flag='Y' or msiv.process_costing_enabled_flag='Y') order by ood.organization_code, msiv.concatenated_segments OPM item process and recipe attributes: lists process-manufacturing-relevant items with their recipe / process-execution / quality / costing enabled flags, grade control and default grade, lot and child-lot control, shelf-life control and days. org_access_view inventory-org security; optional Organization Code / Item / Item Status parameters. US OPM Item Process and Recipe Attributes Oracle Process Manufacturing (OPM) item attributes: for every process-manufacturing-enabled item, its recipe, process-execution, quality and costing enabled flags, grade control and default grade, lot / child-lot control, lot divisibility, and shelf-life control and days. Lets formulation and QA teams see which items are recipe and process enabled. 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 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 Item 3 30 1=1 msiv.inventory_item_status_code=:p_item_status LOV custom Y select misv.inventory_item_status_code value, misv.description from mtl_item_status_vl misv order by misv.inventory_item_status_code US Item Status