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) 53860F993F6C7167E0630100007F1025 OPM Test Y select distinct gqt.test_code value, gqtt.test_desc description from gmd_qc_tests_b gqt, gmd_qc_tests_tl gqtt where gqt.test_id=gqtt.test_id and gqtt.language=userenv('lang') order by gqt.test_code US OPM quality test code and description 53840B0694D1768DE0630100007FF85BY select ood.organization_code, gsb.spec_name, gsb.spec_vers, gstl.spec_desc, gsv.meaning spec_status, msiv.concatenated_segments item, msiv.description item_description, gsb.grade, gqt.test_code, gqtt.test_desc, nvl(to_char(gstv.min_value_num),gstv.min_value_char) min_value, to_char(gstv.target_value_num) target_value, nvl(to_char(gstv.max_value_num),gstv.max_value_char) max_value, gstv.test_qty_uom uom, xxen_util.yes(gstv.print_on_coa_ind) print_on_coa, gstv.report_precision from gmd_specifications_b gsb, gmd_specifications_tl gstl, gmd_spec_tests_vl gstv, gmd_qc_tests_b gqt, gmd_qc_tests_tl gqtt, mtl_system_items_vl msiv, org_organization_definitions ood, gmd_status_vl gsv where 1=1 and gsb.owner_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 gsb.spec_id=gstl.spec_id and gstl.language=userenv('lang') and gsb.spec_id=gstv.spec_id and gstv.test_id=gqt.test_id and gqt.test_id=gqtt.test_id and gqtt.language=userenv('lang') and gsb.inventory_item_id=msiv.inventory_item_id and gsb.owner_organization_id=msiv.organization_id and gsb.owner_organization_id=ood.organization_id and gsv.status_code(+)=gsb.spec_status order by ood.organization_code, gsb.spec_name, gsb.spec_vers, gqt.test_code OPM Quality specifications and test limits: each GMD specification with its version, status, item and grade, and per-test minimum/target/maximum limits, UOM, CoA-print flag and report precision - the quality-standard master. org_access_view inventory-org security; optional Organization Code / Item / Spec / Spec Status / Grade / Test parameters. US OPM Specifications and Test Limits Oracle Process Manufacturing (OPM) Quality specifications and test limits: every GMD specification with its version and status, the item and grade it applies to, and each specification test's minimum, target and maximum limits, UOM, certificate-of-analysis print flag and report precision. The master reference for an organization's quality standards. 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 gsb.spec_name=:p_spec_name LOV custom Y select distinct gsb.spec_name value, null description from gmd_specifications_b gsb, mtl_parameters mp where gsb.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 gsb.spec_name US Spec 4 40 1=1 gsb.spec_status=:p_spec_status LOV custom Y select gsv.status_code id, gsv.meaning value, null description from gmd_status_vl gsv order by to_number(gsv.status_code) US Spec Status 5 50 1=1 gsb.grade=:p_grade LOV custom Y select distinct gsb.grade value, null description from gmd_specifications_b gsb, mtl_parameters mp where gsb.grade is not null and gsb.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 gsb.grade US Grade 6 60 1=1 gqt.test_code=:p_test LOV OPM Test 53860F993F6C7167E0630100007F1025 Y select distinct gqt.test_code value, gqtt.test_desc description from gmd_qc_tests_b gqt, gmd_qc_tests_tl gqtt where gqt.test_id=gqtt.test_id and gqtt.language=userenv('lang') order by gqt.test_code US Test