EGO_CHANGE_STATUS_CODES_VL
Details
-
Schema: FUSION
-
Object owner: EGO
-
Object type: VIEW
Columns
| Name |
|---|
|
STATUS_CODE STATUS_NAME LANGUAGE SOURCE_LANG |
Query
| SQL_Statement |
|---|
|
SELECT STATUS_CODE, STATUS_NAME, LANGUAGE, SOURCE_LANG FROM EGO_CHANGE_STATUSES_TL WHERE STATUS_CODE IN (SELECT STATUS_CODE FROM EGO_CHANGE_STATUSES_B WHERE STATUS_TYPE != 20) UNION SELECT 0, MESSAGE_TEXT, LANGUAGE, SOURCE_LANG FROM FND_MESSAGES_TL WHERE MESSAGE_NAME = 'EGO_DRAFT' |