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) 538574176DFB43FFE0630100007FB7A7 select ood.organization_code, msiv.concatenated_segments item, msiv.description item_description, ccd.calendar_code, gps.period_code, cmm.cost_mthd_code cost_method, cmm.cost_mthd_desc cost_method_desc, ccmv.cost_cmpntcls_code cost_component_class, ccmv.cost_cmpntcls_desc cost_component_class_desc, ccd.cost_analysis_code, ccd.cmpnt_cost component_cost, ccd.total_qty from cm_cmpt_dtl ccd, mtl_system_items_vl msiv, cm_cmpt_mst_vl ccmv, cm_mthd_mst cmm, gmf_period_statuses gps, org_organization_definitions ood where 1=1 and ccd.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 ccd.inventory_item_id=msiv.inventory_item_id and ccd.organization_id=msiv.organization_id and ccd.cost_cmpntcls_id=ccmv.cost_cmpntcls_id and ccd.cost_type_id=cmm.cost_type_id and ccd.period_id=gps.period_id(+) and ccd.organization_id=ood.organization_id and nvl(ccd.delete_mark,0)=0 order by ood.organization_code, msiv.concatenated_segments, ccd.calendar_code, gps.period_code, ccmv.cost_cmpntcls_code OPM item cost detail: standard/frozen item cost broken out by cost component class and analysis code per cost calendar/period/method, from cm_cmpt_dtl. org_access_view inventory-org security; optional Organization Code / Item / Cost Calendar / Cost Method / Cost Component Class parameters. Y US CAC OPM Item Cost Detail Oracle Process Manufacturing (OPM) item cost detail: the costed value of each item broken out by cost component class (material, labor, burden, overhead) and cost analysis code, per cost calendar, period and method. Answers what makes up an item's OPM cost. 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 ccd.calendar_code=:p_calendar_code LOV custom Y select distinct ccd.calendar_code value, null description from cm_cmpt_dtl ccd, mtl_parameters mp where ccd.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 ccd.calendar_code US Cost Calendar 4 40 1=1 cmm.cost_mthd_code=:p_cost_method LOV custom Y select distinct cmm.cost_mthd_code value, cmm.cost_mthd_desc description from cm_mthd_mst cmm order by cmm.cost_mthd_code US Cost Method 5 50 1=1 ccmv.cost_cmpntcls_code=:p_cost_component_class LOV custom Y select ccmv.cost_cmpntcls_code value, ccmv.cost_cmpntcls_desc description from cm_cmpt_mst_vl ccmv order by ccmv.cost_cmpntcls_code US Cost Component Class :$flex$.organization_code Organization Code Cost Calendar :$flex$.organization_code Organization Code Item