VIEW: APPS.PSB_BUDGET_WORKFLOW_RULES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)