VIEW: APPS.FND_RESPONSIBILITY_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')