DBA Data[Home] [Help]

APPS.INV_ATTACHMENTS_UTILS dependencies on FND_DOCUMENTS_LONG_TEXT

Line 137: fnd_documents_long_text f

133: from fnd_attached_documents a,
134: fnd_documents b,
135: fnd_documents_vl c,
136: fnd_document_categories_vl d,
137: fnd_documents_long_text f
138: where a.ENTITY_NAME = 'MTL_CATEGORIES'
139: and a.PK1_VALUE = k_category_id
140: and a.DOCUMENT_ID = b.document_id
141: and b.datatype_id = 2 -- long text

Line 203: fnd_documents_long_text f

199: from fnd_attached_documents a,
200: fnd_documents b,
201: fnd_documents_vl c,
202: fnd_document_categories_vl d,
203: fnd_documents_long_text f
204: where a.ENTITY_NAME = 'MTL_SYSTEM_ITEMS'
205: and a.PK1_VALUE = k_organization_id
206: and a.PK2_VALUE = k_inventory_item_id
207: and a.DOCUMENT_ID = b.document_id

Line 280: fnd_documents_long_text f

276: from fnd_attached_documents a,
277: fnd_documents b,
278: fnd_documents_vl c,
279: fnd_document_categories_vl d,
280: fnd_documents_long_text f
281: where a.ENTITY_NAME = 'OE_ORDER_LINES'
282: and a.PK1_VALUE = to_char(k_trx_source_line_id) --Performance bug#9743038
283: and a.DOCUMENT_ID = b.document_id
284: and b.datatype_id = 2 -- long text