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

80: , k_document_category NUMBER)
81: is
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'

Line 85: fnd_documents_vl c,

81: is
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

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

117: , k_category_id NUMBER)
118: is
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'

Line 122: fnd_documents_vl c,

118: is
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

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

142: , k_document_category NUMBER)
143: is
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'

Line 147: fnd_documents_vl c,

143: is
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

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

170: , k_document_category NUMBER)
171: is
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'

Line 175: fnd_documents_vl c,

171: is
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

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

214: k_trx_source_line_id NUMBER )
215: is
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'

Line 219: fnd_documents_vl c,

215: is
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

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

Line 239: fnd_documents b,

235: k_trx_source_line_id NUMBER)
236: is
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'

Line 240: fnd_documents_vl c,

236: is
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

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