1. Tables and Views for SCM
  2. EGO_CHANGE_STATUS_CODE_TYPE_VL

EGO_CHANGE_STATUS_CODE_TYPE_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 EGO_CHANGE_STATUSES_TL.LANGUAGE = USERENV('LANG')

UNION

SELECT 9 STATUS_CODE,

MESSAGE_TEXT STATUS_NAME,

LANGUAGE,

SOURCE_LANG

FROM FND_MESSAGES_TL

WHERE MESSAGE_NAME = 'EGO_FAILED' AND FND_MESSAGES_TL.LANGUAGE = USERENV('LANG')

UNION

SELECT 0 STATUS_CODE,

MESSAGE_TEXT STATUS_NAME,

LANGUAGE,

SOURCE_LANG

FROM FND_MESSAGES_TL

WHERE MESSAGE_NAME = 'EGO_DRAFT' AND FND_MESSAGES_TL.LANGUAGE = USERENV('LANG')

UNION

SELECT 2 STATUS_CODE,

MESSAGE_TEXT STATUS_NAME,

LANGUAGE,

SOURCE_LANG

FROM FND_MESSAGES_TL

WHERE MESSAGE_NAME = 'EGO_ON_HOLD' AND FND_MESSAGES_TL.LANGUAGE = USERENV('LANG')

UNION

SELECT 5 STATUS_CODE,

MESSAGE_TEXT STATUS_NAME,

LANGUAGE,

SOURCE_LANG

FROM FND_MESSAGES_TL

WHERE MESSAGE_NAME = 'EGO_CANCELED' AND FND_MESSAGES_TL.LANGUAGE = USERENV('LANG')