DBA Data[Home] [Help]

APPS.RRS_SITE_UTILS dependencies on MTL_UOM_CONVERSIONS

Line 432: exists (select 1 from MTL_UOM_CONVERSIONS

428: MTL_UNITS_OF_MEASURE
429: WHERE
430: LANGUAGE = USERENV('LANG')
431: and (BASE_UOM_FLAG = 'Y' or
432: exists (select 1 from MTL_UOM_CONVERSIONS
433: where MTL_UNITS_OF_MEASURE .UOM_CLASS = MTL_UOM_CONVERSIONS.UOM_CLASS
434: and MTL_UNITS_OF_MEASURE .UNIT_OF_MEASURE = MTL_UOM_CONVERSIONS.UNIT_OF_MEASURE) )
435: and (DISABLE_DATE is null or DISABLE_DATE >= sysdate)
436: and UOM_CLASS = c_uom_class

Line 433: where MTL_UNITS_OF_MEASURE .UOM_CLASS = MTL_UOM_CONVERSIONS.UOM_CLASS

429: WHERE
430: LANGUAGE = USERENV('LANG')
431: and (BASE_UOM_FLAG = 'Y' or
432: exists (select 1 from MTL_UOM_CONVERSIONS
433: where MTL_UNITS_OF_MEASURE .UOM_CLASS = MTL_UOM_CONVERSIONS.UOM_CLASS
434: and MTL_UNITS_OF_MEASURE .UNIT_OF_MEASURE = MTL_UOM_CONVERSIONS.UNIT_OF_MEASURE) )
435: and (DISABLE_DATE is null or DISABLE_DATE >= sysdate)
436: and UOM_CLASS = c_uom_class
437: ORDER BY

Line 434: and MTL_UNITS_OF_MEASURE .UNIT_OF_MEASURE = MTL_UOM_CONVERSIONS.UNIT_OF_MEASURE) )

430: LANGUAGE = USERENV('LANG')
431: and (BASE_UOM_FLAG = 'Y' or
432: exists (select 1 from MTL_UOM_CONVERSIONS
433: where MTL_UNITS_OF_MEASURE .UOM_CLASS = MTL_UOM_CONVERSIONS.UOM_CLASS
434: and MTL_UNITS_OF_MEASURE .UNIT_OF_MEASURE = MTL_UOM_CONVERSIONS.UNIT_OF_MEASURE) )
435: and (DISABLE_DATE is null or DISABLE_DATE >= sysdate)
436: and UOM_CLASS = c_uom_class
437: ORDER BY
438: BASE_UOM_FLAG DESC;