EGO_CHANGE_AUD_ACT_MIG

Details

Schema: FUSION
Object owner: EGO
Object type: VIEW

Columns

Name
LOOKUP_TYPE LOOKUP_CODE MEANING LANGUAGE SOURCE_LANG

Name

LOOKUP_TYPE

LOOKUP_CODE

MEANING

LANGUAGE

SOURCE_LANG

Query

SQL_Statement
select LOOKUP_TYPE, LOOKUP_CODE, MEANING, LANGUAGE, SOURCE_LANG from FND_LOOKUP_VALUES_TL where LOOKUP_TYPE in ('ORA_EGO_CHG_AUD_ACT','ORA_EGO_CHG_AUD_ACT_TYPE') UNION SELECT 'ORA_EGO_CHG_AUD_ACT' LOOKUP_TYPE, MIG_DATA.ATTRIBUTE_VALUE LOOKUP_CODE, MIG_DATA.ATTRIBUTE_VALUE MEANING, 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='SUB_ACTION_TYPE_VALUE' and MIG_DATA.ATTRIBUTE_VALUE NOT IN (select LOOKUP_CODE FROM FND_LOOKUP_VALUES_B where LOOKUP_TYPE='ORA_EGO_CHG_AUD_ACT') UNION SELECT 'ORA_EGO_CHG_AUD_ACT_TYPE' LOOKUP_TYPE, MIG_DATA.ATTRIBUTE_VALUE LOOKUP_CODE, MIG_DATA.ATTRIBUTE_VALUE MEANING, 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='ACTION_TYPE_VALUE' and MIG_DATA.ATTRIBUTE_VALUE NOT IN (select LOOKUP_CODE FROM FND_LOOKUP_VALUES_B where LOOKUP_TYPE='ORA_EGO_CHG_AUD_ACT_TYPE')

SQL_Statement

select LOOKUP_TYPE, LOOKUP_CODE, MEANING, LANGUAGE, SOURCE_LANG from FND_LOOKUP_VALUES_TL where LOOKUP_TYPE in ('ORA_EGO_CHG_AUD_ACT','ORA_EGO_CHG_AUD_ACT_TYPE')

UNION

SELECT 'ORA_EGO_CHG_AUD_ACT' LOOKUP_TYPE, MIG_DATA.ATTRIBUTE_VALUE LOOKUP_CODE, MIG_DATA.ATTRIBUTE_VALUE MEANING, 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='SUB_ACTION_TYPE_VALUE'

and MIG_DATA.ATTRIBUTE_VALUE NOT IN (select LOOKUP_CODE FROM FND_LOOKUP_VALUES_B where LOOKUP_TYPE='ORA_EGO_CHG_AUD_ACT')

UNION

SELECT 'ORA_EGO_CHG_AUD_ACT_TYPE' LOOKUP_TYPE, MIG_DATA.ATTRIBUTE_VALUE LOOKUP_CODE, MIG_DATA.ATTRIBUTE_VALUE MEANING, 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='ACTION_TYPE_VALUE' and MIG_DATA.ATTRIBUTE_VALUE NOT IN (select LOOKUP_CODE FROM FND_LOOKUP_VALUES_B where LOOKUP_TYPE='ORA_EGO_CHG_AUD_ACT_TYPE')