[Home] [Help]
View: OE_SYS_PARAMETER_DEF_VL
View Text
SELECT SP.PARAMETER_CODE
, TL.NAME
, TL.DESCRIPTION
, SP.CREATION_DATE
, SP.CREATED_BY
, SP.LAST_UPDATE_DATE
, SP.LAST_UPDATED_BY
, SP.LAST_UPDATE_LOGIN
, SP.CATEGORY_CODE
, SP.VALUE_SET_ID
, SP.OPEN_ORDERS_CHECK_FLAG
, SP.SEEDED_FLAG
, SP.ENABLED_FLAG
FROM OE_SYS_PARAMETER_DEF_B SP
, OE_SYS_PARAMETER_DEF_TL TL
WHERE SP.PARAMETER_CODE = TL.PARAMETER_CODE
AND TL.LANGUAGE = USERENV('LANG')
Columns
| Name |
| PARAMETER_CODE |
| NAME |
| DESCRIPTION |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN |
| CATEGORY_CODE |
| VALUE_SET_ID |
| OPEN_ORDERS_CHECK_FLAG |
| SEEDED_FLAG |
| ENABLED_FLAG |
APPS.OE_SYS_PARAMETER_DEF_VL