Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSB_BUDGET_WORKFLOW_RULES_V |
SELECT BWR.ROWID
, BWR.BUDGET_WORKFLOW_RULE_ID
, BWR.NAME
, BWR.DESCRIPTION
, BWR.BUDGET_GROUP_ID
, BG.NAME
, BWR.STAGE_ID
, CATLVL.NAME
, BWR.OVERRIDE_STAGE_ID
, OVER.NAME
, BWR.REVIEW_BUDGET_GROUP_ID
, AUTH.NAME
, BWR.APPROVAL_OPTION
, BG.SET_OF_BOOKS_ID
, SOB.CHART_OF_ACCOUNTS_ID
, BG.BUSINESS_GROUP_ID
, BG.BUDGET_GROUP_CATEGORY_SET_ID
, STG.NAME
, BWR.LAST_UPDATE_DATE
, BWR.LAST_UPDATED_BY
, BWR.LAST_UPDATE_LOGIN
, BWR.CREATED_BY
, BWR.CREATION_DATE
, BWR.ATTRIBUTE1
, BWR.ATTRIBUTE2
, BWR.ATTRIBUTE3
, BWR.ATTRIBUTE4
, BWR.ATTRIBUTE5
, BWR.ATTRIBUTE6
, BWR.ATTRIBUTE7
, BWR.ATTRIBUTE8
, BWR.ATTRIBUTE9
, BWR.ATTRIBUTE10
, BWR.CONTEXT
, BWR.ACCOUNT_OR_POSITION_TYPE
, BWR.DATA_EXTRACT_ID
, DE.DATA_EXTRACT_NAME
FROM PSB_BUDGET_WORKFLOW_RULES BWR
, PSB_BUDGET_GROUPS BG
, GL_SETS_OF_BOOKS SOB
, PSB_BUDGET_GROUPS AUTH
, PSB_BUDGET_STAGES CATLVL
, PSB_BUDGET_STAGES OVER
, PSB_BUDGET_STAGE_SETS STG
, PSB_DATA_EXTRACTS DE
WHERE BWR.BUDGET_GROUP_ID = BG.BUDGET_GROUP_ID
AND BWR.STAGE_ID = CATLVL.BUDGET_STAGE_ID(+)
AND BWR.OVERRIDE_STAGE_ID = OVER.BUDGET_STAGE_ID(+)
AND BWR.REVIEW_BUDGET_GROUP_ID = AUTH.BUDGET_GROUP_ID(+)
AND BG.BUDGET_GROUP_CATEGORY_SET_ID = STG.BUDGET_STAGE_SET_ID
AND BG.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID(+)
AND BWR.DATA_EXTRACT_ID = DE.DATA_EXTRACT_ID(+)