eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_ECO_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 523: From mtl_system_items msi

519: 2 -- HOLD
520: )
521: And exists (
522: Select null
523: From mtl_system_items msi
524: Where msi.inventory_item_id = eri.revised_item_id
525: And msi.organization_id = eri.organization_Id
526: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
527: And rownum = 1

Line 839: From mtl_system_items msi

835: 2 -- HOLD
836: )
837: And exists (
838: Select null
839: From mtl_system_items msi
840: Where msi.inventory_item_id = eri.revised_item_id
841: And msi.organization_id = eri.organization_Id
842: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
843: And rownum = 1

Line 1475: From mtl_system_items msi

1471: 2 -- HOLD
1472: )
1473: And exists (
1474: Select null
1475: From mtl_system_items msi
1476: Where msi.inventory_item_id = eri.revised_item_id
1477: And msi.organization_id = eri.organization_Id
1478: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
1479: );

Line 1522: mtl_system_items msi

1518: p_requestor_id,
1519: substr(p_comment, 1, 240),
1520: eri.revised_item_sequence_id
1521: From eng_revised_items eri,
1522: mtl_system_items msi
1523: Where eri.change_id = p_change_id
1524: And eri.revised_item_id = msi.inventory_item_id
1525: And eri.organization_id = msi.organization_id
1526: And eri.status_type not in ( 5, -- CANCELLED

Line 1635: FROM mtl_system_items msi

1631: 9, -- IMPLEMENTATION_IN_PROGRESS
1632: 2 -- HOLD
1633: )
1634: AND exists (SELECT null
1635: FROM mtl_system_items msi
1636: WHERE msi.inventory_item_id = eri.revised_item_id
1637: AND msi.organization_id = eri.organization_Id
1638: AND msi.bom_item_type in (X_Model, X_OptionClass,
1639: X_Planning, X_Standard)));

Line 1670: FROM mtl_system_items msi

1666: 9, -- IMPLEMENTATION_IN_PROGRESS
1667: 2 -- HOLD
1668: )
1669: AND exists (SELECT null
1670: FROM mtl_system_items msi
1671: WHERE msi.inventory_item_id = eri.revised_item_id
1672: AND msi.organization_id = eri.organization_Id
1673: AND msi.bom_item_type in (X_Model, X_OptionClass,
1674: X_Planning, X_Standard)));

Line 1912: From mtl_system_items msi

1908: 2 -- HOLD
1909: )
1910: And exists (
1911: Select null
1912: From mtl_system_items msi
1913: Where msi.inventory_item_id = eri.revised_item_id
1914: And msi.organization_id = eri.organization_Id
1915: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
1916: );

Line 2025: FROM mtl_system_items msi

2021: 9, -- IMPLEMENTATION_IN_PROGRESS
2022: 2 -- HOLD
2023: )
2024: AND exists (SELECT null
2025: FROM mtl_system_items msi
2026: WHERE msi.inventory_item_id = eri.revised_item_id
2027: AND msi.organization_id = eri.organization_Id
2028: AND msi.bom_item_type in (X_Model, X_OptionClass,
2029: X_Planning, X_Standard)));

Line 2056: FROM mtl_system_items msi

2052: 9, -- IMPLEMENTATION_IN_PROGRESS
2053: 2 -- HOLD
2054: )
2055: AND exists (SELECT null
2056: FROM mtl_system_items msi
2057: WHERE msi.inventory_item_id = eri.revised_item_id
2058: AND msi.organization_id = eri.organization_Id
2059: AND msi.bom_item_type in (X_Model, X_OptionClass,
2060: X_Planning, X_Standard)));

Line 2951: FROM mtl_system_items msi

2947: AND eri.status_type not in (5,6) -- Cancelled or Implemented
2948: AND exists
2949: -- modify only those items which the user has access to
2950: (SELECT null
2951: FROM mtl_system_items msi
2952: WHERE msi.inventory_item_id = eri.revised_item_id
2953: AND msi.organization_id = eri.organization_id
2954: AND msi.bom_item_type IN
2955: (l_STD_Item_Access

Line 4265: from mtl_system_items msi

4261:
4262:
4263: cursor getcataloggroupid(item_id NUMBER, l_org_id NUMBER) is
4264: SELECT ITEM_CATALOG_GROUP_ID
4265: from mtl_system_items msi
4266: where msi.INVENTORY_ITEM_ID = item_id
4267: AND msi.ORGANIZATION_ID = l_org_id;
4268:
4269:

Line 4500: FROM MTL_System_items_vl

4496: THEN
4497: BEGIN
4498: SELECT CURRENT_PHASE_ID
4499: INTO l_change_subject_unexp_rec.lifecycle_state_id
4500: FROM MTL_System_items_vl
4501: WHERE INVENTORY_ITEM_ID = l_change_subject_unexp_rec.pk1_value
4502: AND ORGANIZATION_ID = l_change_subject_unexp_rec.pk2_value;
4503: EXCEPTION
4504: WHEN NO_DATA_FOUND THEN