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 402: EXISTS (SELECT UOM_CODE FROM MTL_UOM_CONVERSIONS MUC_UOM

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: )
405: AND EXISTS
406: (SELECT lookup_code

Line 499: EXISTS (SELECT UOM_CODE FROM MTL_UOM_CONVERSIONS MUC_UOM

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