APPS.GR_ATTACH_DOCUMENTS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 119: and inventory_item_id = (select distinct inventory_item_id from mtl_system_items where segment1 = l_doc.doc_attribute1)

115: FROM WSH_DELIVERABLES_V
116: WHERE container_flag = 'N'
117: and source_code = 'OE'
118: and released_status in ('N', 'R', 'S', 'Y', 'B', 'X')
119: and inventory_item_id = (select distinct inventory_item_id from mtl_system_items where segment1 = l_doc.doc_attribute1)
120: and organization_id = (SELECT organization_id FROM mtl_parameters WHERE organization_code = l_doc.doc_attribute5)
121: and source_header_number = l_doc.doc_attribute8
122: and source_line_number = to_number(l_doc.doc_attribute9)
123: Order by delivery_detail_id;