MSC_SR_LOOKUP_VALUES

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
ENABLED_FLAG LOOKUP_CODE LOOKUP_TYPE START_DATE_ACTIVE END_DATE_ACTIVE REFRESH_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE MEANING DESCRIPTION SET_ID VIEW_APPLICATION_ID

Name

ENABLED_FLAG

LOOKUP_CODE

LOOKUP_TYPE

START_DATE_ACTIVE

END_DATE_ACTIVE

REFRESH_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

LAST_UPDATE_DATE

MEANING

DESCRIPTION

SET_ID

VIEW_APPLICATION_ID

Query

SQL_Statement
SELECT MSC_SR_LOOKUP_VALUES_B.ENABLED_FLAG ENABLED_FLAG, MSC_SR_LOOKUP_VALUES_B.LOOKUP_CODE LOOKUP_CODE, MSC_SR_LOOKUP_VALUES_B.LOOKUP_TYPE LOOKUP_TYPE, MSC_SR_LOOKUP_VALUES_B.START_DATE_ACTIVE START_DATE_ACTIVE, MSC_SR_LOOKUP_VALUES_B.END_DATE_ACTIVE END_DATE_ACTIVE, MSC_SR_LOOKUP_VALUES_B.REFRESH_NUMBER REFRESH_NUMBER, MSC_SR_LOOKUP_VALUES_B.CREATED_BY CREATED_BY, MSC_SR_LOOKUP_VALUES_B.CREATION_DATE CREATION_DATE, MSC_SR_LOOKUP_VALUES_B.LAST_UPDATED_BY LAST_UPDATED_BY, MSC_SR_LOOKUP_VALUES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MSC_SR_LOOKUP_VALUES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, MSC_SR_LOOKUP_VALUES_TL.MEANING MEANING, MSC_SR_LOOKUP_VALUES_TL.DESCRIPTION DESCRIPTION , 0 SET_ID, 0 VIEW_APPLICATION_ID FROM MSC_SR_LOOKUP_VALUES_B, MSC_SR_LOOKUP_VALUES_TL WHERE MSC_SR_LOOKUP_VALUES_TL.LOOKUP_TYPE = MSC_SR_LOOKUP_VALUES_B.LOOKUP_TYPE AND MSC_SR_LOOKUP_VALUES_TL.LOOKUP_CODE = MSC_SR_LOOKUP_VALUES_B.LOOKUP_CODE AND MSC_SR_LOOKUP_VALUES_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

MSC_SR_LOOKUP_VALUES_B.ENABLED_FLAG ENABLED_FLAG,

MSC_SR_LOOKUP_VALUES_B.LOOKUP_CODE LOOKUP_CODE,

MSC_SR_LOOKUP_VALUES_B.LOOKUP_TYPE LOOKUP_TYPE,

MSC_SR_LOOKUP_VALUES_B.START_DATE_ACTIVE START_DATE_ACTIVE,

MSC_SR_LOOKUP_VALUES_B.END_DATE_ACTIVE END_DATE_ACTIVE,

MSC_SR_LOOKUP_VALUES_B.REFRESH_NUMBER REFRESH_NUMBER,

MSC_SR_LOOKUP_VALUES_B.CREATED_BY CREATED_BY,

MSC_SR_LOOKUP_VALUES_B.CREATION_DATE CREATION_DATE,

MSC_SR_LOOKUP_VALUES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

MSC_SR_LOOKUP_VALUES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

MSC_SR_LOOKUP_VALUES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

MSC_SR_LOOKUP_VALUES_TL.MEANING MEANING,

MSC_SR_LOOKUP_VALUES_TL.DESCRIPTION DESCRIPTION ,

0 SET_ID,

0 VIEW_APPLICATION_ID

FROM

MSC_SR_LOOKUP_VALUES_B,

MSC_SR_LOOKUP_VALUES_TL

WHERE

MSC_SR_LOOKUP_VALUES_TL.LOOKUP_TYPE = MSC_SR_LOOKUP_VALUES_B.LOOKUP_TYPE AND MSC_SR_LOOKUP_VALUES_TL.LOOKUP_CODE = MSC_SR_LOOKUP_VALUES_B.LOOKUP_CODE AND MSC_SR_LOOKUP_VALUES_TL.LANGUAGE = USERENV('LANG')