DBA Data[Home] [Help]

VIEW: APPS.JTM_MTL_UNITS_OF_MEASURE_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.UNIT_OF_MEASURE , B.UOM_CODE , B.UOM_CLASS , B.BASE_UOM_FLAG , B.DISABLE_DATE , B.UNIT_OF_MEASURE_TL , B.LANGUAGE FROM MTL_UNITS_OF_MEASURE_TL B , JTM_MTL_UNITS_OF_MEAS_ACC ACC WHERE B.UNIT_OF_MEASURE = ACC.UNIT_OF_MEASURE AND B.LANGUAGE = ASG_BASE.GET_LANGUAGE
View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.UNIT_OF_MEASURE
, B.UOM_CODE
, B.UOM_CLASS
, B.BASE_UOM_FLAG
, B.DISABLE_DATE
, B.UNIT_OF_MEASURE_TL
, B.LANGUAGE
FROM MTL_UNITS_OF_MEASURE_TL B
, JTM_MTL_UNITS_OF_MEAS_ACC ACC
WHERE B.UNIT_OF_MEASURE = ACC.UNIT_OF_MEASURE
AND B.LANGUAGE = ASG_BASE.GET_LANGUAGE