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) 1A5739C5DE270375E0630100007F5142 OPM Status Code Y select gsv.status_code value, gsv.description description from gmd_status_vl gsv order by to_number(gsv.status_code) US 53840B0694CC768DE0630100007FF85BY select ood.organization_code, ffm.formula_no, ffm.formula_vers, ffm.formula_desc1, gsv.meaning formula_status, ffm.total_input_qty, ffm.total_output_qty, decode(fmd.line_type,-1,'Ingredient',1,'Product',2,'By-Product') line_type, fmd.line_no, msiv.concatenated_segments item, msiv.description item_description, fmd.qty, fmd.detail_uom uom, fmd.scrap_factor, gl.meaning scale_type, fmd.prod_percent, xxen_util.yes(fmd.contribute_yield_ind) contributes_to_yield from fm_form_mst ffm, fm_matl_dtl fmd, mtl_system_items_vl msiv, org_organization_definitions ood, gmd_status_vl gsv, gem_lookups gl where 1=1 and fmd.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 ffm.formula_id=fmd.formula_id and fmd.inventory_item_id=msiv.inventory_item_id and fmd.organization_id=msiv.organization_id and fmd.organization_id=ood.organization_id and gsv.status_code(+)=ffm.formula_status and gl.lookup_type(+)='SCALE_TYPE' and gl.lookup_code(+)=fmd.scale_type order by ood.organization_code, ffm.formula_no, ffm.formula_vers, fmd.line_no OPM Product Development formula report: ingredient/product/by-product detail lines per formula with quantity, UOM, scrap factor, scaling type and yield contribution. org_access_view inventory-org security; optional Organization Code / Formula / Item / Formula Status / Line Type parameters. US OPM Formula Details Oracle Process Manufacturing (OPM) Product Development formula details: the ingredient, product and by-product lines of each formula with quantities, UOM, scrap factor, scaling type, planned product percentage and yield contribution. Supports formulation review and data quality checks. 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 ffm.formula_no=:p_formula_no LOV custom Y select distinct ffm.formula_no value, ffm.formula_desc1 description from fm_form_mst ffm, mtl_parameters mp where ffm.owner_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 ffm.formula_no US Formula 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 Item 4 40 1=1 ffm.formula_status=:p_formula_status LOV OPM Status Code 1A5739C5DE270375E0630100007F5142 Y select gsv.status_code value, gsv.description description from gmd_status_vl gsv order by to_number(gsv.status_code) US Formula Status 5 50 1=1 fmd.line_type=:p_line_type LOV custom Y select '-1' id, 'Ingredient' value, null description from dual union all select '1' id, 'Product' value, null description from dual union all select '2' id, 'By-Product' value, null description from dual US Line Type