APPS.EAM_ACTIVITYASSOCIATION_PVT dependencies on MTL_SYSTEM_ITEMS

Line 223: FROM mtl_system_items

219: SELECT eam_activity_cause_code, eam_activity_type_code, eam_act_notification_flag,
220: eam_act_shutdown_status, eam_activity_source_code
221: INTO l_activity_cause_code, l_activity_type_code, l_tagging_required_flag,
222: l_shutdown_type_code, l_activity_source_code
223: FROM mtl_system_items
224: WHERE inventory_item_id = p_target_activity_id
225: AND organization_id = p_target_org_id;
226: EXCEPTION
227: WHEN OTHERS THEN

Line 689: FROM mtl_system_items

685: END IF;
686:
687: -- Validate Activity
688: SELECT count(*) INTO l_count
689: FROM mtl_system_items
690: WHERE organization_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Organization_Id
691: AND inventory_item_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Asset_Activity_Id
692: AND eam_item_type = 2;
693:

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