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_DOCUMENT_CATEGORIES_VL

Line 76: When query fnd_document_categories_vl use of user_name should not done since it is translated value. Instead of column 'NAME' should be used which will not be translated and

72: l_attachments_number number := 0;
73: l_category_id number;
74: l_trx_source_line_id number;
75: /*Fixed for bug#8347410
76: When query fnd_document_categories_vl use of user_name should not done since it is translated value. Instead of column 'NAME' should be used which will not be translated and
77: unique with language_code
78: */
79: l_To_Mobile_Receiver CONSTANT VARCHAR2(30) := 'CUSTOM1323';
80: l_To_Mobile_Putaway CONSTANT VARCHAR2(30) := 'CUSTOM1324';

Line 93: fnd_document_categories_vl d,

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
97: from mtl_item_categories_v e

Line 104: When query fnd_document_categories_vl use of user_name should not

100: and a.DOCUMENT_ID = b.document_id
101: and b.datatype_id = 1 -- short text
102: and b.category_id = d.category_id
103: /*Fixed for bug#8347410
104: When query fnd_document_categories_vl use of user_name should not
105: done since it is translated value. Instead of column 'NAME'
106: should be used which will not be translated and
107: unique with language_code
108: */

Line 136: fnd_document_categories_vl d,

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
140: and a.DOCUMENT_ID = b.document_id

Line 144: When query fnd_document_categories_vl use of user_name should not

140: and a.DOCUMENT_ID = b.document_id
141: and b.datatype_id = 2 -- long text
142: and b.category_id = d.category_id
143: /*Fixed for bug#8347410
144: When query fnd_document_categories_vl use of user_name should not
145: done since it is translated value. Instead of column 'NAME'
146: should be used which will not be translated and
147: unique with language_code
148: */

Line 168: fnd_document_categories_vl d,

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
172: and a.PK2_VALUE = k_inventory_item_id

Line 177: When query fnd_document_categories_vl use of user_name should not

173: and a.DOCUMENT_ID = b.document_id
174: and b.datatype_id = 1 -- short text
175: and b.category_id = d.category_id
176: /*Fixed for bug#8347410
177: When query fnd_document_categories_vl use of user_name should not
178: done since it is translated value. Instead of column 'NAME'
179: should be used which will not be translated and
180: unique with language_code
181: */

Line 202: fnd_document_categories_vl d,

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
206: and a.PK2_VALUE = k_inventory_item_id

Line 211: When query fnd_document_categories_vl use of user_name should not

207: and a.DOCUMENT_ID = b.document_id
208: and b.datatype_id = 2 -- long text
209: and b.category_id = d.category_id
210: /*Fixed for bug#8347410
211: When query fnd_document_categories_vl use of user_name should not
212: done since it is translated value. Instead of column 'NAME'
213: should be used which will not be translated and
214: unique with language_code
215: */

Line 252: fnd_document_categories_vl d,

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
256: and a.DOCUMENT_ID = b.document_id

Line 260: When query fnd_document_categories_vl use of user_name should not

256: and a.DOCUMENT_ID = b.document_id
257: and b.datatype_id = 1 -- short text
258: and b.category_id = d.category_id
259: /*Fixed for bug#8347410
260: When query fnd_document_categories_vl use of user_name should not
261: done since it is translated value. Instead of column 'NAME'
262: should be used which will not be translated and
263: unique with language_code
264: */

Line 279: fnd_document_categories_vl d,

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
283: and a.DOCUMENT_ID = b.document_id

Line 287: When query fnd_document_categories_vl use of user_name should not

283: and a.DOCUMENT_ID = b.document_id
284: and b.datatype_id = 2 -- long text
285: and b.category_id = d.category_id
286: /*Fixed for bug#8347410
287: When query fnd_document_categories_vl use of user_name should not
288: done since it is translated value. Instead of column 'NAME'
289: should be used which will not be translated and
290: unique with language_code
291: */