VIEW: APPS.JTM_FND_RESPONSIBILITY_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_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, T.LANGUAGE, T.SOURCE_LANG FROM FND_RESPONSIBILITY_TL T , FND_RESPONSIBILITY B , JTM_FND_RESPONSIBILITY_ACC ACC WHERE B.RESPONSIBILITY_ID = ACC.RESPONSIBILITY_ID AND B.APPLICATION_ID = ACC.APPLICATION_ID AND B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID AND B.APPLICATION_ID = T.APPLICATION_ID AND T.LANGUAGE = ASG_BASE.GET_LANGUAGE

View Text - HTML Formatted

SELECT ACC.ACCESS_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
, T.LANGUAGE
, T.SOURCE_LANG
FROM FND_RESPONSIBILITY_TL T
, FND_RESPONSIBILITY B
, JTM_FND_RESPONSIBILITY_ACC ACC
WHERE B.RESPONSIBILITY_ID = ACC.RESPONSIBILITY_ID
AND B.APPLICATION_ID = ACC.APPLICATION_ID
AND B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID
AND B.APPLICATION_ID = T.APPLICATION_ID
AND T.LANGUAGE = ASG_BASE.GET_LANGUAGE