[Home] [Help]
887: AND organization_id IN (SELECT organization_id FROM mtl_parameters WHERE master_organization_id=p_organization_id); /* Changed WHERE clause for the Bug 9094912 */
888: End If; /* Fix for bug 10404086 - end of if for update on ego_mtl_sy_items_ext_tl */
889:
890: --Delete attachments which doesnt fall under new catalog hierarchy.
891: DELETE fnd_attached_documents docs
892: WHERE pk2_value = to_char(p_inventory_item_id)
893: AND pk1_value IN (SELECT to_Char(organization_id) FROM mtl_parameters WHERE master_organization_id=p_organization_id) /* Changed WHERE clause for the Bug 9094912 */
894: AND entity_name IN ('MTL_ITEM_REVISIONS','MTL_SYSTEM_ITEMS')
895: AND EXISTS (SELECT NULL
1828: ' ( change.NEW_ITEM_REVISION_ID IS NOT null ' || --this CO creates a revision
1829: ' OR EXISTS ' ||
1830: -- 4177523 DM changes through bug 4045666
1831: -- from CM side to store the pending doc changes in eng_attachment_changes
1832: -- ' (SELECT ''X'' FROM eng_attachment_changes ENG, fnd_attached_documents doc ' ||
1833: -- ' WHERE eng.revised_item_sequence_id = change.revised_item_sequence_id ' ||
1834: -- ' AND eng.attachment_id = doc.attached_document_id ' ||
1835: -- ' AND doc.entity_name = ''MTL_ITEM_REVISIONS'' AND doc.pk1_value = to_char(change.organization_id) ' ||
1836: -- ' AND doc.pk2_value = to_char(:6) AND doc.pk3_value = to_char(:7)) ' ||
2012: ' WHERE change_line_id = change.revised_item_sequence_id ' ||
2013: ' ) OR EXISTS ' ||
2014: -- 4177523 DM changes through bug 4045666
2015: -- from CM side to store the pending doc changes in eng_attachment_changes
2016: -- ' (SELECT ''X'' FROM eng_attachment_changes ENG, fnd_attached_documents doc ' ||
2017: -- ' WHERE eng.revised_item_sequence_id = change.revised_item_sequence_id ' ||
2018: -- ' AND eng.attachment_id = doc.attached_document_id ' ||
2019: -- ' AND doc.entity_name = ''MTL_SYSTEM_ITEMS'' ' ||
2020: -- ' AND doc.pk1_value = to_char(change.organization_id) ' ||