[Home] [Help]
82: select f.short_text
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
119: select f.long_text
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
144: select f.short_text
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
172: select f.long_text
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
216: select f.short_text
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
237: select f.long_text
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