FND Design Data [Home] [Help]

View: FND_RESPONSIBILITY_VL

Product: FND - Application Object Library
Description: View of FND_RESPONSIBILITY and FND_RESPONSIBILITY_TL
Implementation/DBA Data: ViewAPPS.FND_RESPONSIBILITY_VL
View Text

SELECT /* $HEADER$ */ B.ROWID ROW_ID
, B.WEB_HOST_NAME
, B.WEB_AGENT_NAME
, B.APPLICATION_ID
, B.RESPONSIBILITY_ID
, B.RESPONSIBILITY_KEY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.DATA_GROUP_APPLICATION_ID
, B.DATA_GROUP_ID
, B.MENU_ID
, B.START_DATE
, B.END_DATE
, B.GROUP_APPLICATION_ID
, B.REQUEST_GROUP_ID
, B.VERSION
, T.RESPONSIBILITY_NAME
, T.DESCRIPTION
FROM FND_RESPONSIBILITY_TL T
, FND_RESPONSIBILITY B
WHERE B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID
AND B.APPLICATION_ID = T.APPLICATION_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
WEB_HOST_NAME
WEB_AGENT_NAME
APPLICATION_ID
RESPONSIBILITY_ID
RESPONSIBILITY_KEY
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
DATA_GROUP_APPLICATION_ID
DATA_GROUP_ID
MENU_ID
START_DATE
END_DATE
GROUP_APPLICATION_ID
REQUEST_GROUP_ID
VERSION
RESPONSIBILITY_NAME
DESCRIPTION