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 400: FROM Mtl_Units_Of_Measure_TL mtl_uom

396: ,attribute12
397: ,attribute13
398: ,attribute14
399: ,attribute15
400: FROM Mtl_Units_Of_Measure_TL mtl_uom
401: WHERE /* language = userenv('LANG') */
402: EXISTS (SELECT UOM_CODE FROM MTL_UOM_CONVERSIONS MUC_UOM
403: WHERE MUC_UOM.UOM_CODE = MTL_UOM.UOM_CODE
404: )

Line 457: FROM Mtl_Units_Of_Measure_TL mtl_uom

453: ,attribute12
454: ,attribute13
455: ,attribute14
456: ,attribute15
457: FROM Mtl_Units_Of_Measure_TL mtl_uom
458: WHERE mtl_uom.uom_code = p_uom_code
459: /* AND language = userenv('LANG') */
460: AND NOT EXISTS
461: (SELECT lookup_code

Line 470: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2

466: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)
467: AND flv.language = mtl_uom.language
468: )
469: AND rowid = (
470: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2
471: WHERE mtl_uom.unit_of_measure_tl = mtl_uom_2.unit_of_measure_tl
472: AND mtl_uom.language = mtl_uom_2.language
473: ); /*Bug 6740153 added the rowid condition to fetch unique record only */
474: CURSOR cur_new_uom IS /* cursor to select new unit of measure codes which are not present in pa_lookup */

Line 497: FROM Mtl_Units_Of_Measure_TL mtl_uom

493: ,attribute12
494: ,attribute13
495: ,attribute14
496: ,attribute15
497: FROM Mtl_Units_Of_Measure_TL mtl_uom
498: WHERE /* language = userenv('LANG') */
499: EXISTS (SELECT UOM_CODE FROM MTL_UOM_CONVERSIONS MUC_UOM
500: WHERE MUC_UOM.UOM_CODE = MTL_UOM.UOM_CODE
501: )

Line 512: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2

508: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)
509: AND flv.language = mtl_uom.language
510: )
511: AND rowid = (
512: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2
513: WHERE mtl_uom.unit_of_measure_tl = mtl_uom_2.unit_of_measure_tl
514: AND mtl_uom.language = mtl_uom_2.language
515: ); /*Bug 6740153 added the rowid condition to fetch unique record only */
516: /* Removed check for bug 4130638