FND_APPLICATION

Details

• Schema: APPLICATIONS

• Object owner: FND

• Object type: VIEW

Columns

Name
APPLICATION_ID APPLICATION_SHORT_NAME LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN BASEPATH PRODUCT_CODE MODULE_ID

Query

SQL_Statement
SELECT ALTERNATIVE_ID AS APPLICATION_ID, MODULE_NAME AS APPLICATION_SHORT_NAME, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, MODULE_NAME || '_TOP' AS BASEPATH, PRODUCT_CODE, MODULE_ID FROM FND_APPL_TAXONOMY WHERE MODULE_TYPE = 'APPLICATION' AND PRODUCT_LINE = 1