[Home] [Help]
View: PAY_MONETARY_UNITS_VL
View Text
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')
Columns
Name |
ROW_ID |
MONETARY_UNIT_ID |
CURRENCY_CODE |
BUSINESS_GROUP_ID |
LEGISLATION_CODE |
MONETARY_UNIT_NAME |
RELATIVE_VALUE |
COMMENTS |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |