VIEW: APPS.PSB_WS_DISTRIBUTIONS_V

Source

View Text - Preformatted

SELECT dist.rowid, dist.distribution_id, dist.distribution_rule_id, dist.worksheet_id, dist.distribution_date, dist.distributed_flag, dist.distribution_option_flag, dist.revision_option_flag, dist.distribution_instructions, dist.last_update_date, dist.last_updated_by, dist.last_update_login, dist.created_by, dist.creation_date, rules.name, ws.name, ws.budget_group_id, bg.name FROM psb_ws_distributions dist , psb_ws_distribution_rules rules , psb_budget_groups bg, psb_worksheets ws WHERE dist.distribution_rule_id = rules.distribution_rule_id AND dist.worksheet_id = ws.worksheet_id AND bg.budget_group_id = ws.budget_group_id

View Text - HTML Formatted

SELECT DIST.ROWID
, DIST.DISTRIBUTION_ID
, DIST.DISTRIBUTION_RULE_ID
, DIST.WORKSHEET_ID
, DIST.DISTRIBUTION_DATE
, DIST.DISTRIBUTED_FLAG
, DIST.DISTRIBUTION_OPTION_FLAG
, DIST.REVISION_OPTION_FLAG
, DIST.DISTRIBUTION_INSTRUCTIONS
, DIST.LAST_UPDATE_DATE
, DIST.LAST_UPDATED_BY
, DIST.LAST_UPDATE_LOGIN
, DIST.CREATED_BY
, DIST.CREATION_DATE
, RULES.NAME
, WS.NAME
, WS.BUDGET_GROUP_ID
, BG.NAME
FROM PSB_WS_DISTRIBUTIONS DIST
, PSB_WS_DISTRIBUTION_RULES RULES
, PSB_BUDGET_GROUPS BG
, PSB_WORKSHEETS WS
WHERE DIST.DISTRIBUTION_RULE_ID = RULES.DISTRIBUTION_RULE_ID
AND DIST.WORKSHEET_ID = WS.WORKSHEET_ID
AND BG.BUDGET_GROUP_ID = WS.BUDGET_GROUP_ID