Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSB_WS_DISTRIBUTE_RULE_LINES_V |
SELECT DR.ROWID ROW_ID
, BG.BUDGET_GROUP_ID
, BG.NAME
, BG.PARENT_BUDGET_GROUP_ID
, BG.PARENT_NAME
, BG.ROOT_BUDGET_GROUP_ID
, BG.EFFECTIVE_START_DATE
, BG.EFFECTIVE_END_DATE
, DR.DISTRIBUTION_RULE_LINE_ID
, DR.DISTRIBUTION_RULE_ID
, DR.DISTRIBUTE_FLAG
, DR.DISTRIBUTE_ALL_LEVEL_FLAG
, DR.DOWNLOAD_FLAG
, DR.DOWNLOAD_ALL_LEVEL_FLAG
, DR.YEAR_CATEGORY_TYPE
, DR.LAST_UPDATE_DATE
, DR.LAST_UPDATED_BY
, DR.LAST_UPDATE_LOGIN
, DR.CREATED_BY
, DR.CREATION_DATE
, DR.ATTRIBUTE1
, DR.ATTRIBUTE2
, DR.ATTRIBUTE3
, DR.ATTRIBUTE4
, DR.ATTRIBUTE5
, DR.ATTRIBUTE6
, DR.ATTRIBUTE7
, DR.ATTRIBUTE8
, DR.ATTRIBUTE9
, DR.ATTRIBUTE10
, DR.CONTEXT
FROM PSB_BUDGET_GROUPS_V BG
, PSB_WS_DISTRIBUTION_RULE_LINES DR
WHERE BG.BUDGET_GROUP_TYPE = 'R'
AND BG.BUDGET_GROUP_ID = DR.BUDGET_GROUP_ID(+)
AND DR.DISTRIBUTION_RULE_ID(+) = PSB_WS_DISTRIBUTION_RULES_PVT.GET_RULE_ID