ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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 538574176DF943FFE0630100007FB7A7Y select ood.organization_code, msiv.concatenated_segments ingredient_item, msiv.description ingredient_description, fmd.qty ingredient_qty, fmd.detail_uom ingredient_uom, fmd.scrap_factor, ffm.formula_no, ffm.formula_vers, gsv.meaning formula_status, ( select msiv2.concatenated_segments from fm_matl_dtl fmd2, mtl_system_items_vl msiv2 where fmd2.formula_id=ffm.formula_id and fmd2.line_type=1 and fmd2.inventory_item_id=msiv2.inventory_item_id and fmd2.organization_id=msiv2.organization_id and rownum=1 ) product_item, ( select count(distinct grv.recipe_id) from gmd_recipes_vl grv where grv.formula_id=ffm.formula_id ) recipes_using from fm_matl_dtl fmd, fm_form_mst ffm, mtl_system_items_vl msiv, org_organization_definitions ood, gmd_status_vl gsv 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 fmd.line_type=-1 and fmd.formula_id=ffm.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 order by ood.organization_code, msiv.concatenated_segments, ffm.formula_no OPM Product Development formula where-used: which formulas use a given ingredient item (line_type ingredient), with the ingredient quantity/UOM, the using formula and its status, the formula's primary product and the number of recipes using that formula - for ingredient impact / substitution / recall analysis. org_access_view inventory-org security; optional Organization Code / Ingredient Item / Formula Status parameters. US OPM Formula Where-Used Oracle Process Manufacturing (OPM) formula where-used: lists which formulas consume a given ingredient item, with the ingredient quantity and UOM, the using formula and its status, the formula's primary product, and how many recipes use that formula. Supports ingredient impact analysis for substitution, supplier change and allergen / regulatory recall. 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 custom Y Y select distinct msiv.concatenated_segments value, msiv.description from fm_matl_dtl fmd, mtl_system_items_vl msiv, mtl_parameters mp where fmd.line_type=-1 and fmd.inventory_item_id=msiv.inventory_item_id and fmd.organization_id=msiv.organization_id and msiv.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 msiv.concatenated_segments US Ingredient Item 3 30 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