APPS.EAM_COMMON_UTILITIES_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 2670: FROM mtl_system_items_b msi

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

Line 2780: FROM mtl_system_items_b_kfv mtlbkfv

2776: SELECT
2777: mtlbkfv.lot_control_code,
2778: mtlbkfv.serial_number_control_code,
2779: mtlbkfv.revision_qty_control_code
2780: FROM mtl_system_items_b_kfv mtlbkfv
2781: WHERE mtlbkfv.organization_id = c_organization_id
2782: AND mtlbkfv.inventory_item_id = c_inventory_item_id;
2783:
2784: l_is_revision_control BOOLEAN;

Line 3155: mtl_system_items_b msib,

3151: serial_number_control_code
3152: into
3153: l_serial_number_control_code
3154: FROM
3155: mtl_system_items_b msib,
3156: csi_item_instances cii
3157: WHERE
3158: cii.inventory_item_id=msib.inventory_item_id
3159: AND cii.last_vld_organization_id=msib.organization_id

Line 3830: from mtl_system_items_b_kfv msik

3826: return l_return_status;
3827: ELSIF l_maint_object_type = 2 THEN
3828:
3829: select count(1) into l_obj_exists
3830: from mtl_system_items_b_kfv msik
3831: where msik.inventory_item_id = l_maint_object_id
3832: AND msik.organization_id = l_org_id;
3833:
3834: IF l_obj_exists = 1 THEN