VIEW: APPS.PSB_WS_DISTRIBUTE_RULE_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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