APPS.WIP_EAMWORKORDER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 162: FROM mtl_system_items

158:
159: IF (l_maint_obj_fnd<>'Y' AND p_work_order_rec.rebuild_item_id IS NOT NULL) THEN
160: BEGIN
161: SELECT inventory_item_id into l_gen_object_id
162: FROM mtl_system_items
163: WHERE inventory_item_id = p_work_order_rec.rebuild_item_id and organization_id =p_work_order_rec.organization_id;
164: l_maintenance_object_type := 2;
165: l_maintenance_object_id := l_gen_object_id;
166: EXCEPTION

Line 480: FROM MTL_SYSTEM_ITEMS MSI

476: IF (x_activity_cause_code IS NULL) THEN
477: BEGIN
478: SELECT MSI.eam_activity_cause_code
479: INTO x_activity_cause_code
480: FROM MTL_SYSTEM_ITEMS MSI
481: WHERE MSI.inventory_item_id = p_primary_item_id
482: AND MSI.organization_id = p_organization_id;
483: EXCEPTION
484: WHEN OTHERS THEN

Line 696: FROM MTL_SYSTEM_ITEMS MSI

692: IF (x_activity_type_code IS NULL) THEN
693: BEGIN
694: SELECT MSI.eam_activity_type_code
695: INTO x_activity_type_code
696: FROM MTL_SYSTEM_ITEMS MSI
697: WHERE MSI.inventory_item_id = p_primary_item_id
698: AND MSI.organization_id = p_organization_id;
699: EXCEPTION
700: WHEN OTHERS THEN

Line 836: FROM MTL_SYSTEM_ITEMS MSI

832: IF (x_activity_source_code IS NULL) THEN
833: BEGIN
834: SELECT MSI.eam_activity_source_code
835: INTO x_activity_source_code
836: FROM MTL_SYSTEM_ITEMS MSI
837: WHERE MSI.inventory_item_id = p_primary_item_id
838: AND MSI.organization_id = p_organization_id;
839: EXCEPTION
840: WHEN OTHERS THEN

Line 975: FROM MTL_SYSTEM_ITEMS MSI

971: IF (x_shutdown_type_code IS NULL) THEN
972: BEGIN
973: SELECT MSI.eam_act_shutdown_status
974: INTO x_shutdown_type_code
975: FROM MTL_SYSTEM_ITEMS MSI
976: WHERE MSI.inventory_item_id = p_primary_item_id
977: AND MSI.organization_id = p_organization_id;
978: EXCEPTION
979: WHEN OTHERS THEN

Line 1115: FROM MTL_SYSTEM_ITEMS MSI

1111: IF (x_notification_flag IS NULL) THEN
1112: BEGIN
1113: SELECT MSI.eam_act_notification_flag
1114: INTO x_notification_flag
1115: FROM MTL_SYSTEM_ITEMS MSI
1116: WHERE MSI.inventory_item_id = p_primary_item_id
1117: AND MSI.organization_id = p_organization_id;
1118: EXCEPTION
1119: WHEN OTHERS THEN