APPS.EAM_ACTIVITYASSOCIATION_PVT dependencies on MTL_SYSTEM_ITEMS

Line 240: FROM mtl_system_items

236: SELECT eam_activity_cause_code, eam_activity_type_code, eam_act_notification_flag,
237: eam_act_shutdown_status, eam_activity_source_code
238: INTO l_activity_cause_code, l_activity_type_code, l_tagging_required_flag,
239: l_shutdown_type_code, l_activity_source_code
240: FROM mtl_system_items
241: WHERE inventory_item_id = p_target_activity_id
242: AND organization_id = p_target_org_id;
243: EXCEPTION
244: WHEN OTHERS THEN

Line 714: FROM mtl_system_items

710: END IF;
711:
712: -- Validate Activity
713: SELECT count(*) INTO l_count
714: FROM mtl_system_items
715: WHERE organization_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Organization_Id
716: AND inventory_item_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Asset_Activity_Id
717: AND eam_item_type = 2;
718:

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

1096: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Type = 3
1097: THEN
1098: -- type = 3, id is cii.instance_id
1099: SELECT count(cii.instance_id) into l_count
1100: FROM csi_item_instances cii, mtl_system_items_b msi, mtl_parameters mp
1101: WHERE cii.instance_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id
1102: AND mp.organization_id = cii.last_vld_organization_id
1103: AND mp.maint_organization_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Organization_Id
1104: AND cii.last_vld_organization_id = msi.organization_id

Line 1133: FROM mtl_system_items_b msi, mtl_parameters mp

1129: ELSIF l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Type = 2
1130: THEN
1131: -- type = 2
1132: SELECT count(inventory_item_id) into l_count
1133: FROM mtl_system_items_b msi, mtl_parameters mp
1134: WHERE msi.inventory_item_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id
1135: AND mp.maint_organization_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Organization_Id
1136: AND mp.organization_id = msi.organization_id
1137: AND msi.eam_item_type in (1,3);

Line 1212: FROM mtl_system_items_b msi

1208: l_failed := TRUE;
1209: GOTO next_in_loop;
1210: ELSE
1211: SELECT serial_number_control_code into l_count
1212: FROM mtl_system_items_b msi
1213: WHERE msi.inventory_item_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id
1214: AND rownum = 1;
1215:
1216: IF l_count = 1 THEN

Line 1237: FROM mtl_system_items_b msi

1233: END IF;
1234: ELSE
1235: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Type = 2 THEN
1236: SELECT serial_number_control_code into l_count
1237: FROM mtl_system_items_b msi
1238: WHERE msi.inventory_item_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id
1239: AND rownum = 1;
1240:
1241: IF l_count <> 1 THEN