VIEW: APPS.PSBFV_BUDGET_GROUPS

Source

View Text - Preformatted

SELECT BG.SHORT_NAME ,BGR.SHORT_NAME ,BG.NAME ,BG.EFFECTIVE_START_DATE ,BG.EFFECTIVE_END_DATE ,BG.NUM_PROPOSED_YEARS ,BG.ROOT_BUDGET_GROUP ,BG.FREEZE_HIERARCHY_FLAG ,BG.DESCRIPTION ,BG.NARRATIVE_DESCRIPTION ,PSS.NAME ,NPSS.NAME ,SOB.NAME ,SOB.CURRENCY_CODE ,'_DF:PSB:PSB_BUDGET_GROUPS:bg' ,BG.BUDGET_GROUP_ID ,BG.ROOT_BUDGET_GROUP_ID ,BGR.PS_ACCOUNT_POSITION_SET_ID ,BGR.NPS_ACCOUNT_POSITION_SET_ID ,BG.LAST_UPDATE_DATE ,BG.LAST_UPDATED_BY ,BG.CREATED_BY ,BG.CREATION_DATE from PSB_BUDGET_GROUPS BG, PSB_BUDGET_GROUPS BGR, PSB_ACCOUNT_POSITION_SETS PSS, PSB_ACCOUNT_POSITION_SETS NPSS, GL_SETS_OF_BOOKS SOB WHERE DECODE(BG.ROOT_BUDGET_GROUP_ID, NULL, BG.BUDGET_GROUP_ID, BG.ROOT_BUDGET_GROUP_ID) = BGR.BUDGET_GROUP_ID AND BGR.PS_ACCOUNT_POSITION_SET_ID = PSS.ACCOUNT_POSITION_SET_ID AND BGR.NPS_ACCOUNT_POSITION_SET_ID = NPSS.ACCOUNT_POSITION_SET_ID AND BGR.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID with read only

View Text - HTML Formatted

SELECT BG.SHORT_NAME
, BGR.SHORT_NAME
, BG.NAME
, BG.EFFECTIVE_START_DATE
, BG.EFFECTIVE_END_DATE
, BG.NUM_PROPOSED_YEARS
, BG.ROOT_BUDGET_GROUP
, BG.FREEZE_HIERARCHY_FLAG
, BG.DESCRIPTION
, BG.NARRATIVE_DESCRIPTION
, PSS.NAME
, NPSS.NAME
, SOB.NAME
, SOB.CURRENCY_CODE
, '_DF:PSB:PSB_BUDGET_GROUPS:BG'
, BG.BUDGET_GROUP_ID
, BG.ROOT_BUDGET_GROUP_ID
, BGR.PS_ACCOUNT_POSITION_SET_ID
, BGR.NPS_ACCOUNT_POSITION_SET_ID
, BG.LAST_UPDATE_DATE
, BG.LAST_UPDATED_BY
, BG.CREATED_BY
, BG.CREATION_DATE
FROM PSB_BUDGET_GROUPS BG
, PSB_BUDGET_GROUPS BGR
, PSB_ACCOUNT_POSITION_SETS PSS
, PSB_ACCOUNT_POSITION_SETS NPSS
, GL_SETS_OF_BOOKS SOB
WHERE DECODE(BG.ROOT_BUDGET_GROUP_ID
, NULL
, BG.BUDGET_GROUP_ID
, BG.ROOT_BUDGET_GROUP_ID) = BGR.BUDGET_GROUP_ID
AND BGR.PS_ACCOUNT_POSITION_SET_ID = PSS.ACCOUNT_POSITION_SET_ID
AND BGR.NPS_ACCOUNT_POSITION_SET_ID = NPSS.ACCOUNT_POSITION_SET_ID
AND BGR.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID WITH READ ONLY