DBA Data[Home] [Help]

VIEW: APPS.JTM_FND_APPLICATION_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_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, t.LANGUAGE, t.SOURCE_LANG FROM FND_APPLICATION b , FND_APPLICATION_TL t , JTM_FND_APPLICATION_ACC ACC WHERE ACC.APPLICATION_ID = t.APPLICATION_ID AND B.APPLICATION_ID = t.APPLICATION_ID AND t.LANGUAGE = ASG_BASE.GET_LANGUAGE
View Text - HTML Formatted

SELECT ACC.ACCESS_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
, T.LANGUAGE
, T.SOURCE_LANG
FROM FND_APPLICATION B
, FND_APPLICATION_TL T
, JTM_FND_APPLICATION_ACC ACC
WHERE ACC.APPLICATION_ID = T.APPLICATION_ID
AND B.APPLICATION_ID = T.APPLICATION_ID
AND T.LANGUAGE = ASG_BASE.GET_LANGUAGE