eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_ATTACHMENTS_UTILS dependencies on FND_DOCUMENTS

Line 91: fnd_documents b,

87: , k_document_category NUMBER)
88: is
89: select f.short_text
90: from fnd_attached_documents a,
91: fnd_documents b,
92: fnd_documents_vl c,
93: fnd_document_categories_vl d,
94: fnd_documents_short_text f
95: where a.ENTITY_NAME = 'MTL_CATEGORIES'

Line 92: fnd_documents_vl c,

88: is
89: select f.short_text
90: from fnd_attached_documents a,
91: fnd_documents b,
92: fnd_documents_vl c,
93: fnd_document_categories_vl d,
94: fnd_documents_short_text f
95: where a.ENTITY_NAME = 'MTL_CATEGORIES'
96: and a.PK1_VALUE in (select distinct e.category_id

Line 94: fnd_documents_short_text f

90: from fnd_attached_documents a,
91: fnd_documents b,
92: fnd_documents_vl c,
93: fnd_document_categories_vl d,
94: fnd_documents_short_text f
95: where a.ENTITY_NAME = 'MTL_CATEGORIES'
96: and a.PK1_VALUE in (select distinct e.category_id
97: from mtl_item_categories_v e
98: where e.organization_id = k_organization_id

Line 134: fnd_documents b,

130: , k_category_id NUMBER)
131: is
132: select f.long_text
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'

Line 135: fnd_documents_vl c,

131: is
132: select f.long_text
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

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 166: fnd_documents b,

162: , k_document_category NUMBER)
163: is
164: select f.short_text
165: from fnd_attached_documents a,
166: fnd_documents b,
167: fnd_documents_vl c,
168: fnd_document_categories_vl d,
169: fnd_documents_short_text f
170: where a.ENTITY_NAME = 'MTL_SYSTEM_ITEMS'

Line 167: fnd_documents_vl c,

163: is
164: select f.short_text
165: from fnd_attached_documents a,
166: fnd_documents b,
167: fnd_documents_vl c,
168: fnd_document_categories_vl d,
169: fnd_documents_short_text f
170: where a.ENTITY_NAME = 'MTL_SYSTEM_ITEMS'
171: and a.PK1_VALUE = k_organization_id

Line 169: fnd_documents_short_text f

165: from fnd_attached_documents a,
166: fnd_documents b,
167: fnd_documents_vl c,
168: fnd_document_categories_vl d,
169: fnd_documents_short_text f
170: where a.ENTITY_NAME = 'MTL_SYSTEM_ITEMS'
171: and a.PK1_VALUE = k_organization_id
172: and a.PK2_VALUE = k_inventory_item_id
173: and a.DOCUMENT_ID = b.document_id

Line 200: fnd_documents b,

196: , k_document_category NUMBER)
197: is
198: select f.long_text
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'

Line 201: fnd_documents_vl c,

197: is
198: select f.long_text
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

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 250: fnd_documents b,

246: k_trx_source_line_id NUMBER )
247: is
248: select f.short_text
249: from fnd_attached_documents a,
250: fnd_documents b,
251: fnd_documents_vl c,
252: fnd_document_categories_vl d,
253: fnd_documents_short_text f
254: where a.ENTITY_NAME = 'OE_ORDER_LINES'

Line 251: fnd_documents_vl c,

247: is
248: select f.short_text
249: from fnd_attached_documents a,
250: fnd_documents b,
251: fnd_documents_vl c,
252: fnd_document_categories_vl d,
253: fnd_documents_short_text f
254: where a.ENTITY_NAME = 'OE_ORDER_LINES'
255: and a.PK1_VALUE = to_char(k_trx_source_line_id) --Performance bug#9743038

Line 253: fnd_documents_short_text f

249: from fnd_attached_documents a,
250: fnd_documents b,
251: fnd_documents_vl c,
252: fnd_document_categories_vl d,
253: fnd_documents_short_text f
254: where a.ENTITY_NAME = 'OE_ORDER_LINES'
255: and a.PK1_VALUE = to_char(k_trx_source_line_id) --Performance bug#9743038
256: and a.DOCUMENT_ID = b.document_id
257: and b.datatype_id = 1 -- short text

Line 277: fnd_documents b,

273: k_trx_source_line_id NUMBER)
274: is
275: select f.long_text
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'

Line 278: fnd_documents_vl c,

274: is
275: select f.long_text
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

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