[Home] [Help]
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
Name |
PROPOSAL_ID |
VERSION_ID |
BUDGET_PERIOD_ID |
LINE_ITEM_ID |
EXPENDITURE_TYPE |
EXPENDITURE_CATEGORY_FLAG |
BUDGET_CATEGORY_CODE |
BUDGET_CATEGORY |
BASE_AMT |
OH_APPLIED_FLAG |
OH_COST |
EB_COST |