DBA Data[Home] [Help]

APPS.PA_UOM dependencies on MTL_UOM_CONVERSIONS

Line 196: EXISTS (SELECT UOM_CODE FROM MTL_UOM_CONVERSIONS MUC_UOM

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: )
199: AND EXISTS
200: (SELECT lookup_code

Line 301: EXISTS (SELECT UOM_CODE FROM MTL_UOM_CONVERSIONS MUC_UOM

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: )
304: AND EXISTS
305: (SELECT lookup_code

Line 407: EXISTS (SELECT UOM_CODE FROM MTL_UOM_CONVERSIONS MUC_UOM

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: )
410: AND EXISTS
411: (SELECT lookup_code

Line 509: EXISTS (SELECT UOM_CODE FROM MTL_UOM_CONVERSIONS MUC_UOM

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: )
512: AND NOT EXISTS
513: (SELECT lookup_code