VIEW: APPS.FIIBV_PA_PABU_BUDGET_LCV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'