APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 836: DELETE fnd_attached_documents docs

832: SET item_catalog_group_id = p_new_catalog_group_id
833: WHERE inventory_item_id = p_inventory_item_id;
834:
835: --Delete attachments which doesnt fall under new catalog hierarchy.
836: DELETE fnd_attached_documents docs
837: WHERE pk2_value = to_char(p_inventory_item_id)
838: AND entity_name IN ('MTL_ITEM_REVISIONS','MTL_SYSTEM_ITEMS')
839: AND EXISTS (SELECT NULL
840: FROM ego_objtype_attach_cats

Line 1754: -- ' (SELECT ''X'' FROM eng_attachment_changes ENG, fnd_attached_documents doc ' ||

1750: ' ( change.NEW_ITEM_REVISION_ID IS NOT null ' || --this CO creates a revision
1751: ' OR EXISTS ' ||
1752: -- 4177523 DM changes through bug 4045666
1753: -- from CM side to store the pending doc changes in eng_attachment_changes
1754: -- ' (SELECT ''X'' FROM eng_attachment_changes ENG, fnd_attached_documents doc ' ||
1755: -- ' WHERE eng.revised_item_sequence_id = change.revised_item_sequence_id ' ||
1756: -- ' AND eng.attachment_id = doc.attached_document_id ' ||
1757: -- ' AND doc.entity_name = ''MTL_ITEM_REVISIONS'' AND doc.pk1_value = to_char(change.organization_id) ' ||
1758: -- ' AND doc.pk2_value = to_char(:6) AND doc.pk3_value = to_char(:7)) ' ||

Line 1934: -- ' (SELECT ''X'' FROM eng_attachment_changes ENG, fnd_attached_documents doc ' ||

1930: ' WHERE change_line_id = change.revised_item_sequence_id ' ||
1931: ' ) OR EXISTS ' ||
1932: -- 4177523 DM changes through bug 4045666
1933: -- from CM side to store the pending doc changes in eng_attachment_changes
1934: -- ' (SELECT ''X'' FROM eng_attachment_changes ENG, fnd_attached_documents doc ' ||
1935: -- ' WHERE eng.revised_item_sequence_id = change.revised_item_sequence_id ' ||
1936: -- ' AND eng.attachment_id = doc.attached_document_id ' ||
1937: -- ' AND doc.entity_name = ''MTL_SYSTEM_ITEMS'' ' ||
1938: -- ' AND doc.pk1_value = to_char(change.organization_id) ' ||