APPS.ENG_DOM_UTIL_PUB dependencies on MTL_SYSTEM_ITEMS

Line 109: FROM MTL_SYSTEM_ITEMS

105: INTO
106: l_lifecycle_id,
107: l_current_phase_id,
108: l_catalog_id
109: FROM MTL_SYSTEM_ITEMS
110: WHERE inventory_item_id = p_inventory_item_id
111: AND organization_id = p_organization_id;
112: ELSE
113: SELECT REV.lifecycle_id,

Line 120: FROM MTL_ITEM_REVISIONS REV, MTL_SYSTEM_ITEMS IT

116: INTO
117: l_lifecycle_id,
118: l_current_phase_id,
119: l_catalog_id
120: FROM MTL_ITEM_REVISIONS REV, MTL_SYSTEM_ITEMS IT
121: WHERE
122: REV.inventory_item_id = IT.inventory_item_id
123: AND REV.inventory_item_id = p_inventory_item_id
124: AND REV.organization_id = p_organization_id

Line 210: attach_query := attach_query || ' where entity_name = ''MTL_SYSTEM_ITEMS''';

206: and d.dm_node = dn.node_id
207: and dn.PRODUCT_ID = pr.product_id)';
208:
209: IF p_revision_id IS NULL THEN
210: attach_query := attach_query || ' where entity_name = ''MTL_SYSTEM_ITEMS''';
211: ELSE
212: attach_query := attach_query || ' where entity_name = ''MTL_ITEM_REVISIONS''';
213: END IF;
214: