VIEW: APPS.PAY_MONETARY_UNITS_VL

Source

View Text - Preformatted

SELECT MON.ROWID ROW_ID ,MON.MONETARY_UNIT_ID ,MON.CURRENCY_CODE ,MON.BUSINESS_GROUP_ID ,MON.LEGISLATION_CODE ,MONTL.MONETARY_UNIT_NAME ,MON.RELATIVE_VALUE ,MON.COMMENTS ,MON.LAST_UPDATE_DATE ,MON.LAST_UPDATED_BY ,MON.LAST_UPDATE_LOGIN ,MON.CREATED_BY ,MON.CREATION_DATE FROM PAY_MONETARY_UNITS MON ,PAY_MONETARY_UNITS_TL MONTL WHERE MON.MONETARY_UNIT_ID = MONTL.MONETARY_UNIT_ID AND MONTL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT MON.ROWID ROW_ID
, MON.MONETARY_UNIT_ID
, MON.CURRENCY_CODE
, MON.BUSINESS_GROUP_ID
, MON.LEGISLATION_CODE
, MONTL.MONETARY_UNIT_NAME
, MON.RELATIVE_VALUE
, MON.COMMENTS
, MON.LAST_UPDATE_DATE
, MON.LAST_UPDATED_BY
, MON.LAST_UPDATE_LOGIN
, MON.CREATED_BY
, MON.CREATION_DATE
FROM PAY_MONETARY_UNITS MON
, PAY_MONETARY_UNITS_TL MONTL
WHERE MON.MONETARY_UNIT_ID = MONTL.MONETARY_UNIT_ID
AND MONTL.LANGUAGE = USERENV('LANG')