DBA Data[Home] [Help]

APPS.INV_ATTACHMENTS_UTILS dependencies on MTL_ITEM_CATEGORIES_V

Line 90: from mtl_item_categories_v e

86: fnd_document_categories_vl d,
87: fnd_documents_short_text f
88: where a.ENTITY_NAME = 'MTL_CATEGORIES'
89: and a.PK1_VALUE in (select distinct e.category_id
90: from mtl_item_categories_v e
91: where e.organization_id = k_organization_id
92: and e.inventory_item_id = k_inventory_item_id)
93: and a.DOCUMENT_ID = b.document_id
94: and b.datatype_id = 1 -- short text

Line 110: from mtl_item_categories_v

106: k_organization_id NUMBER
107: , k_inventory_item_id NUMBER)
108: is
109: select distinct category_id
110: from mtl_item_categories_v
111: where organization_id = k_organization_id
112: and inventory_item_id = k_inventory_item_id;
113:
114: /* Category - Long Text */