Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSB_BUDGET_GROUPS_V |
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')