APPS.WIP_EAMWORKORDER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 117: csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp

113: BEGIN
114:
115: SELECT msib.eam_item_type into l_eam_item_type
116: FROM
117: csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp
118: WHERE
119: msib.organization_id = mp.organization_id and
120: msib.organization_id = cii.last_vld_organization_id and
121: msib.inventory_item_id = cii.inventory_item_id and

Line 205: FROM mtl_system_items

201:
202: IF (l_maint_obj_fnd<>'Y' AND p_work_order_rec.rebuild_item_id IS NOT NULL) THEN
203: BEGIN
204: SELECT inventory_item_id into l_gen_object_id
205: FROM mtl_system_items
206: WHERE inventory_item_id = p_work_order_rec.rebuild_item_id and organization_id =p_work_order_rec.organization_id;
207: l_maintenance_object_type := 2;
208: l_maintenance_object_id := l_gen_object_id;
209: EXCEPTION

Line 534: FROM MTL_SYSTEM_ITEMS MSI

530: IF (x_activity_cause_code IS NULL) THEN
531: BEGIN
532: SELECT MSI.eam_activity_cause_code
533: INTO x_activity_cause_code
534: FROM MTL_SYSTEM_ITEMS MSI
535: WHERE MSI.inventory_item_id = p_primary_item_id
536: AND MSI.organization_id = p_organization_id;
537: EXCEPTION
538: WHEN OTHERS THEN

Line 761: FROM MTL_SYSTEM_ITEMS MSI

757: IF (x_activity_type_code IS NULL) THEN
758: BEGIN
759: SELECT MSI.eam_activity_type_code
760: INTO x_activity_type_code
761: FROM MTL_SYSTEM_ITEMS MSI
762: WHERE MSI.inventory_item_id = p_primary_item_id
763: AND MSI.organization_id = p_organization_id;
764: EXCEPTION
765: WHEN OTHERS THEN

Line 912: FROM MTL_SYSTEM_ITEMS MSI

908: IF (x_activity_source_code IS NULL) THEN
909: BEGIN
910: SELECT MSI.eam_activity_source_code
911: INTO x_activity_source_code
912: FROM MTL_SYSTEM_ITEMS MSI
913: WHERE MSI.inventory_item_id = p_primary_item_id
914: AND MSI.organization_id = p_organization_id;
915: EXCEPTION
916: WHEN OTHERS THEN

Line 1064: FROM MTL_SYSTEM_ITEMS MSI

1060: IF (x_shutdown_type_code IS NULL) THEN
1061: BEGIN
1062: SELECT MSI.eam_act_shutdown_status
1063: INTO x_shutdown_type_code
1064: FROM MTL_SYSTEM_ITEMS MSI
1065: WHERE MSI.inventory_item_id = p_primary_item_id
1066: AND MSI.organization_id = p_organization_id;
1067: EXCEPTION
1068: WHEN OTHERS THEN

Line 1222: FROM MTL_SYSTEM_ITEMS MSI

1218: IF (x_notification_flag IS NULL) THEN
1219: BEGIN
1220: SELECT MSI.eam_act_notification_flag
1221: INTO x_notification_flag
1222: FROM MTL_SYSTEM_ITEMS MSI
1223: WHERE MSI.inventory_item_id = p_primary_item_id
1224: AND MSI.organization_id = p_organization_id;
1225: EXCEPTION
1226: WHEN OTHERS THEN