DBA Data[Home] [Help]

APPS.INV_ATTACHMENTS_UTILS dependencies on MTL_ITEM_CATEGORIES_V

Line 97: from mtl_item_categories_v e

93: fnd_document_categories_vl d,
94: fnd_documents_short_text f
95: where a.ENTITY_NAME = 'MTL_CATEGORIES'
96: and a.PK1_VALUE in (select distinct e.category_id
97: from mtl_item_categories_v e
98: where e.organization_id = k_organization_id
99: and e.inventory_item_id = k_inventory_item_id)
100: and a.DOCUMENT_ID = b.document_id
101: and b.datatype_id = 1 -- short text

Line 123: from mtl_item_categories_v

119: k_organization_id NUMBER
120: , k_inventory_item_id NUMBER)
121: is
122: select distinct category_id
123: from mtl_item_categories_v
124: where organization_id = k_organization_id
125: and inventory_item_id = k_inventory_item_id;
126:
127: /* Category - Long Text */