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.PA_UOM dependencies on MTL_UNITS_OF_MEASURE_TL

Line 144: FROM Mtl_Units_Of_Measure_TL mtl_uom

140: ,attribute12
141: ,attribute13
142: ,attribute14
143: ,attribute15
144: FROM Mtl_Units_Of_Measure_TL mtl_uom
145: WHERE mtl_uom.uom_code = p_uom_code
146: /* AND language = userenv('LANG') */
147: AND EXISTS
148: (SELECT lookup_code

Line 167: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2

163: AND flv1.security_group_id = fnd_global.lookup_security_group('UNIT',275)
164: AND flv1.language = mtl_uom.language
165: )
166: AND rowid = (
167: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2
168: WHERE mtl_uom.unit_of_measure_tl = mtl_uom_2.unit_of_measure_tl
169: AND mtl_uom.language = mtl_uom_2.language
170: ); /*Bug 6740153 added the rowid condition to fetch unique record only */
171: CURSOR cur_chg_uom_code IS /*cursor to select records whose meaning have been updated by the users in the mtl table */

Line 194: FROM Mtl_Units_Of_Measure_TL mtl_uom

190: ,attribute12
191: ,attribute13
192: ,attribute14
193: ,attribute15
194: FROM Mtl_Units_Of_Measure_TL mtl_uom
195: WHERE /* language = userenv('LANG') */
196: EXISTS (SELECT UOM_CODE FROM MTL_UOM_CONVERSIONS MUC_UOM
197: WHERE MUC_UOM.UOM_CODE = MTL_UOM.UOM_CODE
198: )

Line 219: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2

215: AND flv1.security_group_id = fnd_global.lookup_security_group('UNIT',275)
216: AND flv1.language = mtl_uom.language
217: )
218: AND rowid = (
219: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2
220: WHERE mtl_uom.unit_of_measure_tl = mtl_uom_2.unit_of_measure_tl
221: AND mtl_uom.language = mtl_uom_2.language
222: ); /*Bug 6740153 added the rowid condition to fetch unique record only */
223: /* Removed check for bug 4130638

Line 254: FROM Mtl_Units_Of_Measure_TL mtl_uom

250: ,attribute12
251: ,attribute13
252: ,attribute14
253: ,attribute15
254: FROM Mtl_Units_Of_Measure_TL mtl_uom
255: WHERE mtl_uom.uom_code = p_uom_code
256: /* AND language = userenv('LANG') */
257: AND EXISTS
258: (SELECT lookup_code

Line 299: FROM Mtl_Units_Of_Measure_TL mtl_uom

295: ,attribute12
296: ,attribute13
297: ,attribute14
298: ,attribute15
299: FROM Mtl_Units_Of_Measure_TL mtl_uom
300: WHERE /* language = userenv('LANG') */
301: EXISTS (SELECT UOM_CODE FROM MTL_UOM_CONVERSIONS MUC_UOM
302: WHERE MUC_UOM.UOM_CODE = MTL_UOM.UOM_CODE
303: )

Line 354: FROM Mtl_Units_Of_Measure_TL mtl_uom

350: ,attribute12
351: ,attribute13
352: ,attribute14
353: ,attribute15
354: FROM Mtl_Units_Of_Measure_TL mtl_uom
355: WHERE /* language = userenv('LANG') */
356: mtl_uom.uom_code = p_uom_code
357: AND EXISTS
358: (SELECT lookup_code

Line 377: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2

373: AND flv1.security_group_id = fnd_global.lookup_security_group('UNIT',275)
374: AND flv1.language = mtl_uom.language
375: )
376: AND rowid = ( /*Added this condition for the bug 13539202 */
377: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2
378: WHERE mtl_uom.unit_of_measure_tl = mtl_uom_2.unit_of_measure_tl
379: AND mtl_uom.language = mtl_uom_2.language
380: );
381:

Line 405: FROM Mtl_Units_Of_Measure_TL mtl_uom

401: ,attribute12
402: ,attribute13
403: ,attribute14
404: ,attribute15
405: FROM Mtl_Units_Of_Measure_TL mtl_uom
406: WHERE /* language = userenv('LANG') */
407: EXISTS (SELECT UOM_CODE FROM MTL_UOM_CONVERSIONS MUC_UOM
408: WHERE MUC_UOM.UOM_CODE = MTL_UOM.UOM_CODE
409: )

Line 430: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2

426: AND flv1.security_group_id = fnd_global.lookup_security_group('UNIT',275)
427: AND flv1.language = mtl_uom.language
428: )
429: AND rowid = ( /*Added this condition for the bug 13539202 */
430: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2
431: WHERE mtl_uom.unit_of_measure_tl = mtl_uom_2.unit_of_measure_tl
432: AND mtl_uom.language = mtl_uom_2.language
433: );
434:

Line 467: FROM Mtl_Units_Of_Measure_TL mtl_uom

463: ,attribute12
464: ,attribute13
465: ,attribute14
466: ,attribute15
467: FROM Mtl_Units_Of_Measure_TL mtl_uom
468: WHERE mtl_uom.uom_code = p_uom_code
469: /* AND language = userenv('LANG') */
470: AND NOT EXISTS
471: (SELECT lookup_code

Line 480: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2

476: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)
477: AND flv.language = mtl_uom.language
478: )
479: AND rowid = (
480: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2
481: WHERE mtl_uom.unit_of_measure_tl = mtl_uom_2.unit_of_measure_tl
482: AND mtl_uom.language = mtl_uom_2.language
483: ); /*Bug 6740153 added the rowid condition to fetch unique record only */
484: CURSOR cur_new_uom IS /* cursor to select new unit of measure codes which are not present in pa_lookup */

Line 507: FROM Mtl_Units_Of_Measure_TL mtl_uom

503: ,attribute12
504: ,attribute13
505: ,attribute14
506: ,attribute15
507: FROM Mtl_Units_Of_Measure_TL mtl_uom
508: WHERE /* language = userenv('LANG') */
509: EXISTS (SELECT UOM_CODE FROM MTL_UOM_CONVERSIONS MUC_UOM
510: WHERE MUC_UOM.UOM_CODE = MTL_UOM.UOM_CODE
511: )

Line 522: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2

518: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)
519: --AND flv.language = mtl_uom.language /*Bug 13899806 Commented the condition*/
520: )
521: AND rowid = (
522: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2
523: WHERE mtl_uom.unit_of_measure_tl = mtl_uom_2.unit_of_measure_tl
524: AND mtl_uom.language = mtl_uom_2.language
525: ); /*Bug 6740153 added the rowid condition to fetch unique record only */
526: /* Removed check for bug 4130638