FND Design Data [Home] [Help]

View: FND_APPLICATION_VL

Product: FND - Application Object Library
Description: View of FND_APPLICATION and FND_APPLICATION_TL
Implementation/DBA Data: ViewAPPS.FND_APPLICATION_VL
View Text

SELECT B.ROWID ROW_ID
, B.APPLICATION_ID
, B.APPLICATION_SHORT_NAME
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.BASEPATH
, T.APPLICATION_NAME
, T.DESCRIPTION
, B.PRODUCT_CODE
FROM FND_APPLICATION_TL T
, FND_APPLICATION B
WHERE B.APPLICATION_ID = T.APPLICATION_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
APPLICATION_ID
APPLICATION_SHORT_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
BASEPATH
APPLICATION_NAME
DESCRIPTION
PRODUCT_CODE