1. Tables and Views for SCM
  2. EGO_CHANGE_STATUS_ING_VL

EGO_CHANGE_STATUS_ING_VL

Details

  • Schema: FUSION

  • Object owner: EGO

  • Object type: VIEW

Columns

Name

STATUS_CODE

STATUS_NAME

LANGUAGE

SOURCE_LANG

Query

SQL_Statement

SELECT to_char(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 to_char(0) STATUS_CODE,

MESSAGE_TEXT STATUS_NAME,

LANGUAGE,

SOURCE_LANG

FROM FND_MESSAGES_TL

WHERE MESSAGE_NAME = 'EGO_DRAFT'

UNION

SELECT mig_data.ATTRIBUTE_VALUE STATUS_CODE, mig_data.ATTRIBUTE_VALUE STATUS_NAME, lang.LANGUAGE_CODE LANGUAGE,

lang.LANGUAGE_CODE SOURCE_LANG FROM EGO_AUDIT_MIG_ATTR_DATA mig_data, FND_LANGUAGES lang

where lang.ACTIVATION_STATUS='ACTIVE' and mig_data.ATTRIBUTE_NAME='CO_STATUS_VALUE'