View: FIIBV_PA_PABU_BUDGET_LCV

Product:	FII - Financial Intelligence
Description:	FIIBV_PA_PABU_BUDGET_LCV is the Budget level source view for the Project Budget dimension in EDW
Implementation/DBA Data:	APPS.FIIBV_PA_PABU_BUDGET_LCV

View Text

SELECT BV.BUDGET_VERSION_ID || '-' || SUBSTRB(ELI.INSTANCE_CODE
, 1
, 40)
, PRJ.SEGMENT1 || '
, ' || DECODE( BV.VERSION_NAME
, NULL
, BT.BUDGET_TYPE || ' (' || BV.VERSION_NUMBER || ')'
, BT.BUDGET_TYPE || '
, ' || BV.VERSION_NAME || ' (' || BV.VERSION_NUMBER || ')' )
, BT.BUDGET_TYPE
, DECODE( BV.VERSION_NAME
, NULL
, '(' || BV.VERSION_NUMBER || ')'
, BV.VERSION_NAME || ' (' || BV.VERSION_NUMBER || ')' )
, PRJ.SEGMENT1
, BV.CURRENT_FLAG
, BV.ORIGINAL_FLAG
, BV.CURRENT_ORIGINAL_FLAG
, SUBSTRB(ELI.INSTANCE_CODE
, 1
, 40)
, BV.LAST_UPDATE_DATE
, '_DF:PA:PA_BUDGET_TYPES_DESC_FLEX:BT'
, '_DF:PA:PA_BUDGET_VERSIONS_DESC_FLEX:BV'
, '_DF:PA:PA_PROJECTS_DESC_FLEX:PRJ'
FROM PA_BUDGET_TYPES BT
, PA_BUDGET_VERSIONS BV
, PA_PROJECTS_ALL PRJ
, EDW_LOCAL_INSTANCE ELI
WHERE BV.BUDGET_TYPE_CODE = BT.BUDGET_TYPE_CODE
AND BV.PROJECT_ID = PRJ.PROJECT_ID
AND BV.BUDGET_STATUS_CODE = 'B'

Columns