APPS.EAM_ASSETNUMBER_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 1129: FROM MTL_SYSTEM_ITEMS_B

1125: end if;
1126:
1127: -- Check that the equipment item belongs to the prod org
1128: SELECT count(*) INTO l_count
1129: FROM MTL_SYSTEM_ITEMS_B
1130: WHERE inventory_item_id = l_prod_inventory_item_id
1131: AND organization_id = l_prod_organization_id;
1132: if (l_count = 0) then
1133: x_reason_failed:='EAM_INVALID_EQP_ITEM';

Line 1141: FROM MTL_SYSTEM_ITEMS_B

1137: end if;
1138:
1139: -- Check that the equipment type of the eqp item is 1
1140: SELECT equipment_type INTO l_prod_equipment_type
1141: FROM MTL_SYSTEM_ITEMS_B
1142: WHERE inventory_item_id = l_prod_inventory_item_id
1143: AND organization_id = l_prod_organization_id;
1144:
1145: if (l_prod_equipment_type is null) then