APPS.EAM_ASSETNUMBER_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 1161: FROM MTL_SYSTEM_ITEMS_B

1157: end if;
1158:
1159: -- Check that the equipment item belongs to the prod org
1160: SELECT count(*) INTO l_count
1161: FROM MTL_SYSTEM_ITEMS_B
1162: WHERE inventory_item_id = l_prod_inventory_item_id
1163: AND organization_id = l_prod_organization_id;
1164: if (l_count = 0) then
1165: x_reason_failed:='EAM_INVALID_EQP_ITEM';

Line 1173: FROM MTL_SYSTEM_ITEMS_B

1169: end if;
1170:
1171: -- Check that the equipment type of the eqp item is 1
1172: SELECT equipment_type INTO l_prod_equipment_type
1173: FROM MTL_SYSTEM_ITEMS_B
1174: WHERE inventory_item_id = l_prod_inventory_item_id
1175: AND organization_id = l_prod_organization_id;
1176:
1177: if (l_prod_equipment_type is null) then