DBA Data[Home] [Help]

APPS.INV_ATTACHMENTS_UTILS dependencies on FND_DOCUMENTS_LONG_TEXT

Line 124: fnd_documents_long_text f

120: from fnd_attached_documents a,
121: fnd_documents b,
122: fnd_documents_vl c,
123: fnd_document_categories_vl d,
124: fnd_documents_long_text f
125: where a.ENTITY_NAME = 'MTL_CATEGORIES'
126: and a.PK1_VALUE = k_category_id
127: and a.DOCUMENT_ID = b.document_id
128: and b.datatype_id = 2 -- long text

Line 177: fnd_documents_long_text f

173: from fnd_attached_documents a,
174: fnd_documents b,
175: fnd_documents_vl c,
176: fnd_document_categories_vl d,
177: fnd_documents_long_text f
178: where a.ENTITY_NAME = 'MTL_SYSTEM_ITEMS'
179: and a.PK1_VALUE = k_organization_id
180: and a.PK2_VALUE = k_inventory_item_id
181: and a.DOCUMENT_ID = b.document_id

Line 242: fnd_documents_long_text f

238: from fnd_attached_documents a,
239: fnd_documents b,
240: fnd_documents_vl c,
241: fnd_document_categories_vl d,
242: fnd_documents_long_text f
243: where a.ENTITY_NAME = 'OE_ORDER_LINES'
244: and a.PK1_VALUE = k_trx_source_line_id
245: and a.DOCUMENT_ID = b.document_id
246: and b.datatype_id = 2 -- long text