APPS.EAM_COMMON_UTILITIES_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 2669: FROM mtl_system_items_b msi

2665: SELECT
2666: msi.lot_control_code,
2667: msi.serial_number_control_code,
2668: msi.revision_qty_control_code
2669: FROM mtl_system_items_b msi
2670: WHERE msi.organization_id = c_organization_id
2671: AND msi.inventory_item_id = c_inventory_item_id;
2672:
2673: l_is_revision_control BOOLEAN;

Line 3686: from mtl_system_items_b_kfv msik

3682: return l_return_status;
3683: ELSIF l_maint_object_type = 2 THEN
3684:
3685: select count(1) into l_obj_exists
3686: from mtl_system_items_b_kfv msik
3687: where msik.inventory_item_id = l_maint_object_id
3688: AND msik.organization_id = l_org_id;
3689:
3690: IF l_obj_exists = 1 THEN