APPS.EAM_ACTIVITYASSOCIATION_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1019: FROM csi_item_instances cii, mtl_system_items_b msi, mtl_parameters mp

1015: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Type = 3
1016: THEN
1017: -- type = 3, id is cii.instance_id
1018: SELECT count(cii.instance_id) into l_count
1019: FROM csi_item_instances cii, mtl_system_items_b msi, mtl_parameters mp
1020: WHERE cii.instance_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id
1021: AND mp.organization_id = cii.last_vld_organization_id
1022: AND mp.maint_organization_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Organization_Id
1023: AND cii.last_vld_organization_id = msi.organization_id

Line 1052: FROM mtl_system_items_b msi, mtl_parameters mp

1048: ELSIF l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Type = 2
1049: THEN
1050: -- type = 2
1051: SELECT count(inventory_item_id) into l_count
1052: FROM mtl_system_items_b msi, mtl_parameters mp
1053: WHERE msi.inventory_item_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id
1054: AND mp.maint_organization_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Organization_Id
1055: AND mp.organization_id = msi.organization_id
1056: AND msi.eam_item_type in (1,3);

Line 1131: FROM mtl_system_items_b msi

1127: l_failed := TRUE;
1128: GOTO next_in_loop;
1129: ELSE
1130: SELECT serial_number_control_code into l_count
1131: FROM mtl_system_items_b msi
1132: WHERE msi.inventory_item_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id
1133: AND rownum = 1;
1134:
1135: IF l_count = 1 THEN

Line 1156: FROM mtl_system_items_b msi

1152: END IF;
1153: ELSE
1154: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Type = 2 THEN
1155: SELECT serial_number_control_code into l_count
1156: FROM mtl_system_items_b msi
1157: WHERE msi.inventory_item_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id
1158: AND rownum = 1;
1159:
1160: IF l_count <> 1 THEN