DBA Data[Home] [Help]

APPS.ENG_DOM_UTIL_PUB dependencies on MTL_ITEM_REVISIONS

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 212: attach_query := attach_query || ' where entity_name = ''MTL_ITEM_REVISIONS''';

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:
215: attach_query := attach_query || ' and pk1_value = :1 and pk2_value = :2 and dm_document_id = 0 and protocol = ''WEBSERVICES'' and category_id in ('|| l_att_cat_ids || ')';
216: