eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.PSB_WORKSHEETS_RESP_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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