DBA Data[Home] [Help]

APPS.RRS_SITE_UTILS dependencies on MTL_UNITS_OF_MEASURE

Line 428: MTL_UNITS_OF_MEASURE

424: CURSOR UOM_CURSOR(c_uom_class VARCHAR2) IS
425: SELECT
426: UNIT_OF_MEASURE
427: FROM
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

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;

Line 439: uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

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;
439: uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
440:
441: BEGIN
442:
443: IF(p_uom_class IS NULL) THEN