1101: and bcolu.status = 'BCSO'
1102: and msi.inventory_item_id = bcolu.config_item_id
1103: and not exists
1104: (SELECT 'x'
1105: FROM FND_ATTACHED_DOCUMENTS
1106: WHERE pk1_value = to_char(msi.organization_id)
1107: AND pk2_value = to_char(msi.inventory_item_id)
1108: AND entity_name = 'MTL_SYSTEM_ITEMS');
1109:
2989: --
2990: lStmtNumber := 200;
2991: FOR v_get_org_id in c_get_org_id LOOP
2992:
2993: fnd_attached_documents2_pkg.copy_attachments (
2994: X_from_entity_name => 'MTL_SYSTEM_ITEMS',
2995: X_from_pk1_value => v_get_org_id.src_org_id,
2996: X_from_pk2_value => v_get_org_id.model_item_id,
2997: X_from_pk3_value => NULL,