DBA Data[Home] [Help]

APPS.INV_ATTACHMENTS_UTILS dependencies on FND_DOCUMENTS_SHORT_TEXT

Line 87: fnd_documents_short_text f

83: from fnd_attached_documents a,
84: fnd_documents b,
85: fnd_documents_vl c,
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

Line 149: fnd_documents_short_text f

145: from fnd_attached_documents a,
146: fnd_documents b,
147: fnd_documents_vl c,
148: fnd_document_categories_vl d,
149: fnd_documents_short_text f
150: where a.ENTITY_NAME = 'MTL_SYSTEM_ITEMS'
151: and a.PK1_VALUE = k_organization_id
152: and a.PK2_VALUE = k_inventory_item_id
153: and a.DOCUMENT_ID = b.document_id

Line 221: fnd_documents_short_text f

217: from fnd_attached_documents a,
218: fnd_documents b,
219: fnd_documents_vl c,
220: fnd_document_categories_vl d,
221: fnd_documents_short_text f
222: where a.ENTITY_NAME = 'OE_ORDER_LINES'
223: and a.PK1_VALUE = k_trx_source_line_id
224: and a.DOCUMENT_ID = b.document_id
225: and b.datatype_id = 1 -- short text