[Home] [Help]
View: ENG_CHANGE_TEMPLATES_VL
View Text
SELECT B.ROWID ROW_ID
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CHANGE_TEMPLATE_ID
, B.ORGANIZATION_ID
, B.START_DATE
, B.END_DATE
, T.TEMPLATE_NAME
, T.DESCRIPTION
FROM ENG_CHANGE_TEMPLATES_TL T
, ENG_CHANGE_TEMPLATES_B B
WHERE B.CHANGE_TEMPLATE_ID = T.CHANGE_TEMPLATE_ID
AND T.LANGUAGE = USERENV('LANG')
Columns
| Name |
| ROW_ID |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN |
| CHANGE_TEMPLATE_ID |
| ORGANIZATION_ID |
| START_DATE |
| END_DATE |
| TEMPLATE_NAME |
| DESCRIPTION |
APPS.ENG_CHANGE_TEMPLATES_VL