FND Design Data [Home] [Help]

View: PSB_WORKSHEETS_RESP_V

Product: PSB - Public Sector Budgeting
Description:
Implementation/DBA Data: ViewAPPS.PSB_WORKSHEETS_RESP_V
View Text

SELECT FUR.USER_ID
, FUR.RESPONSIBILITY_ID
, BGR.BUDGET_GROUP_RESP_ID
, BG.BUDGET_GROUP_ID
, WS.WORKSHEET_ID
, WS.NAME
FROM FND_USER_RESP_GROUPS FUR
, PSB_BUDGET_GROUP_RESP BGR
, PSB_BUDGET_GROUPS BG
, PSB_WORKSHEETS WS
WHERE FUR.RESPONSIBILITY_ID = BGR.RESPONSIBILITY_ID
AND BGR.BUDGET_GROUP_ID = BG.BUDGET_GROUP_ID
AND BG.BUDGET_GROUP_ID = WS.BUDGET_GROUP_ID

Columns

Name
USER_ID
RESPONSIBILITY_ID
BUDGET_GROUP_RESP_ID
BUDGET_GROUP_ID
WORKSHEET_ID
WORKSHEET_NAME