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) 538574176DFD43FFE0630100007FB7A7Y select ood.organization_code, msiv_c.concatenated_segments item, mln_c.lot_number lot, mms.status_code lot_status, mln_c.grade_code lot_grade, mln_c.origination_date, mln_c.expiration_date, msiv_p.concatenated_segments parent_item, mln_p.lot_number parent_lot, decode(mog.object_type,1,'Lot',2,'Lot resulting from WIP',5,'Serial') object_type from mtl_object_genealogy mog, mtl_lot_numbers mln_c, mtl_lot_numbers mln_p, mtl_system_items_vl msiv_c, mtl_system_items_vl msiv_p, mtl_material_statuses_vl mms, org_organization_definitions ood where 1=1 and mln_c.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 mog.object_id=mln_c.gen_object_id and mog.parent_object_id=mln_p.gen_object_id(+) and mln_c.inventory_item_id=msiv_c.inventory_item_id and mln_c.organization_id=msiv_c.organization_id and mln_p.inventory_item_id=msiv_p.inventory_item_id(+) and mln_p.organization_id=msiv_p.organization_id(+) and mln_c.status_id=mms.status_id(+) and mln_c.organization_id=ood.organization_id order by ood.organization_code, msiv_c.concatenated_segments, mln_c.lot_number OPM batch lot genealogy: parent-to-child lot relationships from mtl_object_genealogy (resolved to item/lot via gen_object_id), enriched with the child lot's material status, grade, origination and expiration dates - for recall, traceability and lot-status review. org_access_view inventory-org security; optional Organization Code / Item / Lot Number parameters. US OPM Batch Lot Genealogy Oracle Process Manufacturing (OPM) batch lot genealogy: the parent-to-child lot relationships (which ingredient lots produced which product lots), enriched with each lot's material status, grade, origination and expiration dates. Supports recall, quality and where-used lot traceability. 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_c.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 mln_c.lot_number like :p_lot Char US Lot Number like