VIEW: APPS.PSB_BUDGET_GROUPS_V

Source

View Text - Preformatted

SELECT BG.ROWID ,BG.BUDGET_GROUP_ID ,BG.NAME ,BG.SHORT_NAME ,BG.PARENT_BUDGET_GROUP_ID ,BGP.SHORT_NAME ,BGP.NAME ,BGP.EFFECTIVE_START_DATE ,BGP.EFFECTIVE_END_DATE ,BG.ROOT_BUDGET_GROUP ,BG.ROOT_BUDGET_GROUP_ID ,BGR.SHORT_NAME ,BGR.NAME ,BGR.SET_OF_BOOKS_ID ,RSOB.NAME ,RSOB.CHART_OF_ACCOUNTS_ID ,RSOB.CURRENCY_CODE ,BGR.FREEZE_HIERARCHY_FLAG ,BGR.REQUEST_ID ,BGR.BUSINESS_GROUP_ID ,BG.PS_ACCOUNT_POSITION_SET_ID ,NULL ,BG.NPS_ACCOUNT_POSITION_SET_ID ,NULL ,BG.BUDGET_GROUP_CATEGORY_SET_ID ,NULL ,BG.EFFECTIVE_START_DATE ,BG.EFFECTIVE_END_DATE ,BG.FREEZE_HIERARCHY_FLAG ,BG.DESCRIPTION ,BG.SET_OF_BOOKS_ID ,NULL ,to_number(NULL) ,NULL ,BG.BUSINESS_GROUP_ID ,BG.NUM_PROPOSED_YEARS ,BG.NARRATIVE_DESCRIPTION ,BG.BUDGET_GROUP_TYPE ,BG.REQUEST_ID ,BG.LAST_UPDATE_DATE ,BG.LAST_UPDATED_BY ,BG.LAST_UPDATE_LOGIN ,BG.CREATED_BY ,BG.CREATION_DATE ,BG.SEGMENT1_TYPE ,BG.SEGMENT2_TYPE ,BG.SEGMENT3_TYPE ,BG.SEGMENT4_TYPE ,BG.SEGMENT5_TYPE ,BG.SEGMENT6_TYPE ,BG.SEGMENT7_TYPE ,BG.SEGMENT8_TYPE ,BG.SEGMENT9_TYPE ,BG.SEGMENT10_TYPE ,BG.SEGMENT11_TYPE ,BG.SEGMENT12_TYPE ,BG.SEGMENT13_TYPE ,BG.SEGMENT14_TYPE ,BG.SEGMENT15_TYPE ,BG.SEGMENT16_TYPE ,BG.SEGMENT17_TYPE ,BG.SEGMENT18_TYPE ,BG.SEGMENT19_TYPE ,BG.SEGMENT20_TYPE ,BG.SEGMENT21_TYPE ,BG.SEGMENT22_TYPE ,BG.SEGMENT23_TYPE ,BG.SEGMENT24_TYPE ,BG.SEGMENT25_TYPE ,BG.SEGMENT26_TYPE ,BG.SEGMENT27_TYPE ,BG.SEGMENT28_TYPE ,BG.SEGMENT29_TYPE ,BG.SEGMENT30_TYPE ,BG.ATTRIBUTE1 ,BG.ATTRIBUTE2 ,BG.ATTRIBUTE3 ,BG.ATTRIBUTE4 ,BG.ATTRIBUTE5 ,BG.ATTRIBUTE6 ,BG.ATTRIBUTE7 ,BG.ATTRIBUTE8 ,BG.ATTRIBUTE9 ,BG.ATTRIBUTE10 ,BG.CONTEXT ,BG.ORGANIZATION_ID ,ORG.NAME FROM PSB_BUDGET_GROUPS BG, PSB_BUDGET_GROUPS BGP, PSB_BUDGET_GROUPS BGR, GL_SETS_OF_BOOKS RSOB, HR_ALL_ORGANIZATION_UNITS_TL ORG WHERE NVL(BG.ROOT_BUDGET_GROUP, 'N') = 'N' AND BG.PARENT_BUDGET_GROUP_ID = BGP.BUDGET_GROUP_ID AND BG.ROOT_BUDGET_GROUP_ID = BGR.BUDGET_GROUP_ID AND BGR.SET_OF_BOOKS_ID = RSOB.SET_OF_BOOKS_ID AND BG.ORGANIZATION_ID = ORG.ORGANIZATION_ID(+) AND ORG.LANGUAGE (+) = USERENV('LANG') UNION ALL SELECT BG.ROWID ,BG.BUDGET_GROUP_ID ,BG.NAME ,BG.SHORT_NAME ,BG.PARENT_BUDGET_GROUP_ID ,NULL ,NULL ,to_date(NULL) ,to_date(NULL) ,BG.ROOT_BUDGET_GROUP ,BG.ROOT_BUDGET_GROUP_ID ,NULL ,NULL ,to_number(NULL) ,NULL ,to_number(NULL) ,NULL ,NULL ,to_number(NULL) ,to_number(NULL) ,BG.PS_ACCOUNT_POSITION_SET_ID ,PSS.NAME ,BG.NPS_ACCOUNT_POSITION_SET_ID ,NPSS.NAME ,BG.BUDGET_GROUP_CATEGORY_SET_ID ,ST.NAME ,BG.EFFECTIVE_START_DATE ,BG.EFFECTIVE_END_DATE ,BG.FREEZE_HIERARCHY_FLAG ,BG.DESCRIPTION ,BG.SET_OF_BOOKS_ID ,SOB.NAME ,SOB.CHART_OF_ACCOUNTS_ID ,SOB.CURRENCY_CODE ,BG.BUSINESS_GROUP_ID ,BG.NUM_PROPOSED_YEARS ,BG.NARRATIVE_DESCRIPTION ,BG.BUDGET_GROUP_TYPE ,BG.REQUEST_ID ,BG.LAST_UPDATE_DATE ,BG.LAST_UPDATED_BY ,BG.LAST_UPDATE_LOGIN ,BG.CREATED_BY ,BG.CREATION_DATE ,BG.SEGMENT1_TYPE ,BG.SEGMENT2_TYPE ,BG.SEGMENT3_TYPE ,BG.SEGMENT4_TYPE ,BG.SEGMENT5_TYPE ,BG.SEGMENT6_TYPE ,BG.SEGMENT7_TYPE ,BG.SEGMENT8_TYPE ,BG.SEGMENT9_TYPE ,BG.SEGMENT10_TYPE ,BG.SEGMENT11_TYPE ,BG.SEGMENT12_TYPE ,BG.SEGMENT13_TYPE ,BG.SEGMENT14_TYPE ,BG.SEGMENT15_TYPE ,BG.SEGMENT16_TYPE ,BG.SEGMENT17_TYPE ,BG.SEGMENT18_TYPE ,BG.SEGMENT19_TYPE ,BG.SEGMENT20_TYPE ,BG.SEGMENT21_TYPE ,BG.SEGMENT22_TYPE ,BG.SEGMENT23_TYPE ,BG.SEGMENT24_TYPE ,BG.SEGMENT25_TYPE ,BG.SEGMENT26_TYPE ,BG.SEGMENT27_TYPE ,BG.SEGMENT28_TYPE ,BG.SEGMENT29_TYPE ,BG.SEGMENT30_TYPE ,BG.ATTRIBUTE1 ,BG.ATTRIBUTE2 ,BG.ATTRIBUTE3 ,BG.ATTRIBUTE4 ,BG.ATTRIBUTE5 ,BG.ATTRIBUTE6 ,BG.ATTRIBUTE7 ,BG.ATTRIBUTE8 ,BG.ATTRIBUTE9 ,BG.ATTRIBUTE10 ,BG.CONTEXT , BG.BUSINESS_GROUP_ID ,ORG.NAME FROM PSB_BUDGET_GROUPS BG, PSB_ACCOUNT_POSITION_SETS PSS, PSB_ACCOUNT_POSITION_SETS NPSS, GL_SETS_OF_BOOKS SOB, PSB_BUDGET_STAGE_SETS ST, HR_ALL_ORGANIZATION_UNITS_TL ORG WHERE BG.ROOT_BUDGET_GROUP = 'Y' AND BG.PS_ACCOUNT_POSITION_SET_ID = PSS.ACCOUNT_POSITION_SET_ID (+) AND BG.NPS_ACCOUNT_POSITION_SET_ID = NPSS.ACCOUNT_POSITION_SET_ID (+) AND BG.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID AND BG.BUDGET_GROUP_CATEGORY_SET_ID = ST.BUDGET_STAGE_SET_ID (+) AND BG.BUSINESS_GROUP_ID = ORG.ORGANIZATION_ID(+) AND ORG.LANGUAGE (+) = USERENV('LANG')

View Text - HTML Formatted

SELECT BG.ROWID
, BG.BUDGET_GROUP_ID
, BG.NAME
, BG.SHORT_NAME
, BG.PARENT_BUDGET_GROUP_ID
, BGP.SHORT_NAME
, BGP.NAME
, BGP.EFFECTIVE_START_DATE
, BGP.EFFECTIVE_END_DATE
, BG.ROOT_BUDGET_GROUP
, BG.ROOT_BUDGET_GROUP_ID
, BGR.SHORT_NAME
, BGR.NAME
, BGR.SET_OF_BOOKS_ID
, RSOB.NAME
, RSOB.CHART_OF_ACCOUNTS_ID
, RSOB.CURRENCY_CODE
, BGR.FREEZE_HIERARCHY_FLAG
, BGR.REQUEST_ID
, BGR.BUSINESS_GROUP_ID
, BG.PS_ACCOUNT_POSITION_SET_ID
, NULL
, BG.NPS_ACCOUNT_POSITION_SET_ID
, NULL
, BG.BUDGET_GROUP_CATEGORY_SET_ID
, NULL
, BG.EFFECTIVE_START_DATE
, BG.EFFECTIVE_END_DATE
, BG.FREEZE_HIERARCHY_FLAG
, BG.DESCRIPTION
, BG.SET_OF_BOOKS_ID
, NULL
, TO_NUMBER(NULL)
, NULL
, BG.BUSINESS_GROUP_ID
, BG.NUM_PROPOSED_YEARS
, BG.NARRATIVE_DESCRIPTION
, BG.BUDGET_GROUP_TYPE
, BG.REQUEST_ID
, BG.LAST_UPDATE_DATE
, BG.LAST_UPDATED_BY
, BG.LAST_UPDATE_LOGIN
, BG.CREATED_BY
, BG.CREATION_DATE
, BG.SEGMENT1_TYPE
, BG.SEGMENT2_TYPE
, BG.SEGMENT3_TYPE
, BG.SEGMENT4_TYPE
, BG.SEGMENT5_TYPE
, BG.SEGMENT6_TYPE
, BG.SEGMENT7_TYPE
, BG.SEGMENT8_TYPE
, BG.SEGMENT9_TYPE
, BG.SEGMENT10_TYPE
, BG.SEGMENT11_TYPE
, BG.SEGMENT12_TYPE
, BG.SEGMENT13_TYPE
, BG.SEGMENT14_TYPE
, BG.SEGMENT15_TYPE
, BG.SEGMENT16_TYPE
, BG.SEGMENT17_TYPE
, BG.SEGMENT18_TYPE
, BG.SEGMENT19_TYPE
, BG.SEGMENT20_TYPE
, BG.SEGMENT21_TYPE
, BG.SEGMENT22_TYPE
, BG.SEGMENT23_TYPE
, BG.SEGMENT24_TYPE
, BG.SEGMENT25_TYPE
, BG.SEGMENT26_TYPE
, BG.SEGMENT27_TYPE
, BG.SEGMENT28_TYPE
, BG.SEGMENT29_TYPE
, BG.SEGMENT30_TYPE
, BG.ATTRIBUTE1
, BG.ATTRIBUTE2
, BG.ATTRIBUTE3
, BG.ATTRIBUTE4
, BG.ATTRIBUTE5
, BG.ATTRIBUTE6
, BG.ATTRIBUTE7
, BG.ATTRIBUTE8
, BG.ATTRIBUTE9
, BG.ATTRIBUTE10
, BG.CONTEXT
, BG.ORGANIZATION_ID
, ORG.NAME
FROM PSB_BUDGET_GROUPS BG
, PSB_BUDGET_GROUPS BGP
, PSB_BUDGET_GROUPS BGR
, GL_SETS_OF_BOOKS RSOB
, HR_ALL_ORGANIZATION_UNITS_TL ORG
WHERE NVL(BG.ROOT_BUDGET_GROUP
, 'N') = 'N'
AND BG.PARENT_BUDGET_GROUP_ID = BGP.BUDGET_GROUP_ID
AND BG.ROOT_BUDGET_GROUP_ID = BGR.BUDGET_GROUP_ID
AND BGR.SET_OF_BOOKS_ID = RSOB.SET_OF_BOOKS_ID
AND BG.ORGANIZATION_ID = ORG.ORGANIZATION_ID(+)
AND ORG.LANGUAGE (+) = USERENV('LANG') UNION ALL SELECT BG.ROWID
, BG.BUDGET_GROUP_ID
, BG.NAME
, BG.SHORT_NAME
, BG.PARENT_BUDGET_GROUP_ID
, NULL
, NULL
, TO_DATE(NULL)
, TO_DATE(NULL)
, BG.ROOT_BUDGET_GROUP
, BG.ROOT_BUDGET_GROUP_ID
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, BG.PS_ACCOUNT_POSITION_SET_ID
, PSS.NAME
, BG.NPS_ACCOUNT_POSITION_SET_ID
, NPSS.NAME
, BG.BUDGET_GROUP_CATEGORY_SET_ID
, ST.NAME
, BG.EFFECTIVE_START_DATE
, BG.EFFECTIVE_END_DATE
, BG.FREEZE_HIERARCHY_FLAG
, BG.DESCRIPTION
, BG.SET_OF_BOOKS_ID
, SOB.NAME
, SOB.CHART_OF_ACCOUNTS_ID
, SOB.CURRENCY_CODE
, BG.BUSINESS_GROUP_ID
, BG.NUM_PROPOSED_YEARS
, BG.NARRATIVE_DESCRIPTION
, BG.BUDGET_GROUP_TYPE
, BG.REQUEST_ID
, BG.LAST_UPDATE_DATE
, BG.LAST_UPDATED_BY
, BG.LAST_UPDATE_LOGIN
, BG.CREATED_BY
, BG.CREATION_DATE
, BG.SEGMENT1_TYPE
, BG.SEGMENT2_TYPE
, BG.SEGMENT3_TYPE
, BG.SEGMENT4_TYPE
, BG.SEGMENT5_TYPE
, BG.SEGMENT6_TYPE
, BG.SEGMENT7_TYPE
, BG.SEGMENT8_TYPE
, BG.SEGMENT9_TYPE
, BG.SEGMENT10_TYPE
, BG.SEGMENT11_TYPE
, BG.SEGMENT12_TYPE
, BG.SEGMENT13_TYPE
, BG.SEGMENT14_TYPE
, BG.SEGMENT15_TYPE
, BG.SEGMENT16_TYPE
, BG.SEGMENT17_TYPE
, BG.SEGMENT18_TYPE
, BG.SEGMENT19_TYPE
, BG.SEGMENT20_TYPE
, BG.SEGMENT21_TYPE
, BG.SEGMENT22_TYPE
, BG.SEGMENT23_TYPE
, BG.SEGMENT24_TYPE
, BG.SEGMENT25_TYPE
, BG.SEGMENT26_TYPE
, BG.SEGMENT27_TYPE
, BG.SEGMENT28_TYPE
, BG.SEGMENT29_TYPE
, BG.SEGMENT30_TYPE
, BG.ATTRIBUTE1
, BG.ATTRIBUTE2
, BG.ATTRIBUTE3
, BG.ATTRIBUTE4
, BG.ATTRIBUTE5
, BG.ATTRIBUTE6
, BG.ATTRIBUTE7
, BG.ATTRIBUTE8
, BG.ATTRIBUTE9
, BG.ATTRIBUTE10
, BG.CONTEXT
, BG.BUSINESS_GROUP_ID
, ORG.NAME
FROM PSB_BUDGET_GROUPS BG
, PSB_ACCOUNT_POSITION_SETS PSS
, PSB_ACCOUNT_POSITION_SETS NPSS
, GL_SETS_OF_BOOKS SOB
, PSB_BUDGET_STAGE_SETS ST
, HR_ALL_ORGANIZATION_UNITS_TL ORG
WHERE BG.ROOT_BUDGET_GROUP = 'Y'
AND BG.PS_ACCOUNT_POSITION_SET_ID = PSS.ACCOUNT_POSITION_SET_ID (+)
AND BG.NPS_ACCOUNT_POSITION_SET_ID = NPSS.ACCOUNT_POSITION_SET_ID (+)
AND BG.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
AND BG.BUDGET_GROUP_CATEGORY_SET_ID = ST.BUDGET_STAGE_SET_ID (+)
AND BG.BUSINESS_GROUP_ID = ORG.ORGANIZATION_ID(+)
AND ORG.LANGUAGE (+) = USERENV('LANG')