FND_APPL_TAXONOMY

Details

Schema: TAXONOMY
Object owner: FND
Object type: VIEW

Columns

Name
MODULE_ID PRODUCT_LINE MODULE_NAME MODULE_TYPE PILLAR_NAME MODULE_KEY PRODUCT_CODE DESCRIPTION ALTERNATIVE_ID USAGE_TYPE IS_SEED_DATA_ALLOWED ENTERPRISE_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN USER_MODULE_NAME WEBAPP_SHORT_NAME START_DATE END_DATE

Name

MODULE_ID

PRODUCT_LINE

MODULE_NAME

MODULE_TYPE

PILLAR_NAME

MODULE_KEY

PRODUCT_CODE

DESCRIPTION

ALTERNATIVE_ID

USAGE_TYPE

IS_SEED_DATA_ALLOWED

ENTERPRISE_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

USER_MODULE_NAME

WEBAPP_SHORT_NAME

START_DATE

END_DATE

Query

SQL_Statement
SELECT B.MODULE_ID, B.PRODUCT_LINE, B.MODULE_NAME, B.MODULE_TYPE, B.PILLAR_NAME, B.MODULE_KEY, B.PRODUCT_CODE, T.DESCRIPTION, B.ALTERNATIVE_ID, B.USAGE_TYPE, B.IS_SEED_DATA_ALLOWED, B.ENTERPRISE_ID, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, T.USER_MODULE_NAME, B.WEBAPP_SHORT_NAME, B.START_DATE, B.END_DATE FROM FND_APPL_TAXONOMY_TL T, FND_APPL_TAXONOMY B WHERE B.MODULE_ID = T.MODULE_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.MODULE_ID,

B.PRODUCT_LINE,

B.MODULE_NAME,

B.MODULE_TYPE,

B.PILLAR_NAME,

B.MODULE_KEY,

B.PRODUCT_CODE,

T.DESCRIPTION,

B.ALTERNATIVE_ID,

B.USAGE_TYPE,

B.IS_SEED_DATA_ALLOWED,

B.ENTERPRISE_ID,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.CREATION_DATE,

B.CREATED_BY,

B.LAST_UPDATE_LOGIN,

T.USER_MODULE_NAME,

B.WEBAPP_SHORT_NAME,

B.START_DATE,

B.END_DATE

FROM

FND_APPL_TAXONOMY_TL T,

FND_APPL_TAXONOMY B

WHERE

B.MODULE_ID = T.MODULE_ID AND T.LANGUAGE = USERENV('LANG')