[Home] [Help]
View: 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 |