APPS.ENG_ECO_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 463: From mtl_system_items msi

459: 2 -- HOLD
460: )
461: And exists (
462: Select null
463: From mtl_system_items msi
464: Where msi.inventory_item_id = eri.revised_item_id
465: And msi.organization_id = eri.organization_Id
466: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
467: And rownum = 1

Line 1088: From mtl_system_items msi

1084: 2 -- HOLD
1085: )
1086: And exists (
1087: Select null
1088: From mtl_system_items msi
1089: Where msi.inventory_item_id = eri.revised_item_id
1090: And msi.organization_id = eri.organization_Id
1091: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
1092: );

Line 1135: mtl_system_items msi

1131: p_requestor_id,
1132: substr(p_comment, 1, 240),
1133: eri.revised_item_sequence_id
1134: From eng_revised_items eri,
1135: mtl_system_items msi
1136: Where eri.change_id = p_change_id
1137: And eri.revised_item_id = msi.inventory_item_id
1138: And eri.organization_id = msi.organization_id
1139: And eri.status_type not in ( 5, -- CANCELLED

Line 1248: FROM mtl_system_items msi

1244: 9, -- IMPLEMENTATION_IN_PROGRESS
1245: 2 -- HOLD
1246: )
1247: AND exists (SELECT null
1248: FROM mtl_system_items msi
1249: WHERE msi.inventory_item_id = eri.revised_item_id
1250: AND msi.organization_id = eri.organization_Id
1251: AND msi.bom_item_type in (X_Model, X_OptionClass,
1252: X_Planning, X_Standard)));

Line 1283: FROM mtl_system_items msi

1279: 9, -- IMPLEMENTATION_IN_PROGRESS
1280: 2 -- HOLD
1281: )
1282: AND exists (SELECT null
1283: FROM mtl_system_items msi
1284: WHERE msi.inventory_item_id = eri.revised_item_id
1285: AND msi.organization_id = eri.organization_Id
1286: AND msi.bom_item_type in (X_Model, X_OptionClass,
1287: X_Planning, X_Standard)));

Line 1485: From mtl_system_items msi

1481: 2 -- HOLD
1482: )
1483: And exists (
1484: Select null
1485: From mtl_system_items msi
1486: Where msi.inventory_item_id = eri.revised_item_id
1487: And msi.organization_id = eri.organization_Id
1488: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
1489: );

Line 1598: FROM mtl_system_items msi

1594: 9, -- IMPLEMENTATION_IN_PROGRESS
1595: 2 -- HOLD
1596: )
1597: AND exists (SELECT null
1598: FROM mtl_system_items msi
1599: WHERE msi.inventory_item_id = eri.revised_item_id
1600: AND msi.organization_id = eri.organization_Id
1601: AND msi.bom_item_type in (X_Model, X_OptionClass,
1602: X_Planning, X_Standard)));

Line 1629: FROM mtl_system_items msi

1625: 9, -- IMPLEMENTATION_IN_PROGRESS
1626: 2 -- HOLD
1627: )
1628: AND exists (SELECT null
1629: FROM mtl_system_items msi
1630: WHERE msi.inventory_item_id = eri.revised_item_id
1631: AND msi.organization_id = eri.organization_Id
1632: AND msi.bom_item_type in (X_Model, X_OptionClass,
1633: X_Planning, X_Standard)));

Line 2524: FROM mtl_system_items msi

2520: AND eri.status_type not in (5,6) -- Cancelled or Implemented
2521: AND exists
2522: -- modify only those items which the user has access to
2523: (SELECT null
2524: FROM mtl_system_items msi
2525: WHERE msi.inventory_item_id = eri.revised_item_id
2526: AND msi.organization_id = eri.organization_id
2527: AND msi.bom_item_type IN
2528: (l_STD_Item_Access

Line 3836: from mtl_system_items msi

3832:
3833:
3834: cursor getcataloggroupid(item_id NUMBER, l_org_id NUMBER) is
3835: SELECT ITEM_CATALOG_GROUP_ID
3836: from mtl_system_items msi
3837: where msi.INVENTORY_ITEM_ID = item_id
3838: AND msi.ORGANIZATION_ID = l_org_id;
3839:
3840:

Line 4071: FROM MTL_System_items_vl

4067: THEN
4068: BEGIN
4069: SELECT CURRENT_PHASE_ID
4070: INTO l_change_subject_unexp_rec.lifecycle_state_id
4071: FROM MTL_System_items_vl
4072: WHERE INVENTORY_ITEM_ID = l_change_subject_unexp_rec.pk1_value
4073: AND ORGANIZATION_ID = l_change_subject_unexp_rec.pk2_value;
4074: EXCEPTION
4075: WHEN NO_DATA_FOUND THEN