Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSB_WS_DISTRIBUTIONS_V |
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