View: IGW_BUDGET_CATEGORY_V

Product:	IGW - Grants Proposal
Description:	View to display expenditure type, its budget category and direct costs for budget lines
Implementation/DBA Data:	APPS.IGW_BUDGET_CATEGORY_V

View Text

SELECT PBCV.PROPOSAL_ID
, PBCV.VERSION_ID
, PBCV.BUDGET_PERIOD_ID
, PBCV.LINE_ITEM_ID
, PBCV.EXPENDITURE_TYPE
, PBCV.EXPENDITURE_CATEGORY_FLAG
, PBCV.BUDGET_CATEGORY_CODE
, FL.MEANING BUDGET_CATEGORY
, SUM(PBCV.LINE_ITEM_COST+PBCV.EB_COST) BASE_AMT
, DECODE(PBCV.OH_COST
, 0
, 'N'
, 'Y') OH_APPLIED_FLAG
, PBCV.OH_COST
, PBCV.EB_COST
FROM IGW_BUDGET_COMPLETE_V PBCV
, IGW_LOOKUPS_V FL
WHERE PBCV.BUDGET_CATEGORY_CODE = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'IGW_BUDGET_CATEGORY' GROUP BY PBCV.PROPOSAL_ID
, PBCV.VERSION_ID
, PBCV.BUDGET_PERIOD_ID
, PBCV.BUDGET_CATEGORY_CODE
, FL.MEANING
, PBCV.LINE_ITEM_ID
, PBCV.EXPENDITURE_TYPE
, PBCV.EXPENDITURE_CATEGORY_FLAG

Columns