1. Tables and Views for SCM
  2. EGO_CHANGE_STATUS_TYPES_VL

EGO_CHANGE_STATUS_TYPES_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 = STATUS_CODE AND STATUS_TYPE != 20)

UNION

SELECT 0 STATUS_CODE,

MESSAGE_TEXT STATUS_NAME,

LANGUAGE,

SOURCE_LANG

FROM FND_MESSAGES_TL

WHERE MESSAGE_NAME = 'EGO_DRAFT'

UNION

SELECT 2 STATUS_CODE,

MESSAGE_TEXT STATUS_NAME,

LANGUAGE,

SOURCE_LANG

FROM FND_MESSAGES_TL

WHERE MESSAGE_NAME = 'EGO_ON_HOLD'

UNION

SELECT 5 STATUS_CODE,

MESSAGE_TEXT STATUS_NAME,

LANGUAGE,

SOURCE_LANG

FROM FND_MESSAGES_TL

WHERE MESSAGE_NAME = 'EGO_CANCELED'

UNION

SELECT 9 STATUS_CODE,

MESSAGE_TEXT STATUS_NAME,

LANGUAGE,

SOURCE_LANG

FROM FND_MESSAGES_TL

WHERE MESSAGE_NAME = 'EGO_FAILED'