FUN_LOOKUPS

Details

Schema: FUSION
Object owner: FUN
Object type: VIEW

Columns

Name
LOOKUP_TYPE LOOKUP_CODE MEANING DESCRIPTION ENABLED_FLAG START_DATE_ACTIVE END_DATE_ACTIVE

Name

LOOKUP_TYPE

LOOKUP_CODE

MEANING

DESCRIPTION

ENABLED_FLAG

START_DATE_ACTIVE

END_DATE_ACTIVE

Query

SQL_Statement
SELECT B.LOOKUP_TYPE LOOKUP_TYPE, T.LOOKUP_CODE LOOKUP_CODE, T.MEANING MEANING, T.DESCRIPTION DESCRIPTION, B.ENABLED_FLAG ENABLED_FLAG, B.START_DATE_ACTIVE START_DATE_ACTIVE, B.END_DATE_ACTIVE END_DATE_ACTIVE FROM FND_LOOKUP_VALUES_TL T, FND_LOOKUP_VALUES_B B, FND_LOOKUP_TYPES lkt, FND_APPL_TAXONOMY APPS WHERE T.LANGUAGE = USERENV('LANG') AND T.LOOKUP_TYPE = B.LOOKUP_TYPE AND T.LOOKUP_TYPE = lkt.LOOKUP_TYPE AND T.LOOKUP_CODE = B.LOOKUP_CODE AND T.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND T.SET_ID = B.SET_ID AND lkt.MODULE_ID = APPS.MODULE_ID AND APPS.MODULE_NAME IN ('FinFunIntercoSetup', 'FinFunIntercoTransactions', 'FinFunIntercoAccounting', 'FinFunAccountSequenceUtil', 'FinFunBusinessFunctions')

SQL_Statement

SELECT B.LOOKUP_TYPE LOOKUP_TYPE,

T.LOOKUP_CODE LOOKUP_CODE,

T.MEANING MEANING,

T.DESCRIPTION DESCRIPTION,

B.ENABLED_FLAG ENABLED_FLAG,

B.START_DATE_ACTIVE START_DATE_ACTIVE,

B.END_DATE_ACTIVE END_DATE_ACTIVE

FROM FND_LOOKUP_VALUES_TL T,

FND_LOOKUP_VALUES_B B,

FND_LOOKUP_TYPES lkt,

FND_APPL_TAXONOMY APPS

WHERE T.LANGUAGE = USERENV('LANG')

AND T.LOOKUP_TYPE = B.LOOKUP_TYPE

AND T.LOOKUP_TYPE = lkt.LOOKUP_TYPE

AND T.LOOKUP_CODE = B.LOOKUP_CODE

AND T.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID

AND T.SET_ID = B.SET_ID

AND lkt.MODULE_ID = APPS.MODULE_ID

AND APPS.MODULE_NAME IN ('FinFunIntercoSetup', 'FinFunIntercoTransactions', 'FinFunIntercoAccounting', 'FinFunAccountSequenceUtil', 'FinFunBusinessFunctions')