[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 |
APPS.PAY_MONETARY_UNITS_VL