[Home] [Help]
View: IGW_BUDGET_COMPLETE_V
Product: | IGW - Grants Proposal |
Description: | View to display overhead amounts and employee benefit amounts for budget lines |
Implementation/DBA Data: |
APPS.IGW_BUDGET_COMPLETE_V
|
View Text
SELECT PROPOSAL_ID
, VERSION_ID
, BUDGET_PERIOD_ID
, LINE_ITEM_ID
, IGW_BUDGET_INTEGRATION.GET_LINE_ITEM_COST(LINE_ITEM_ID) LINE_ITEM_COST
, EXPENDITURE_TYPE
, BUDGET_CATEGORY_CODE
, EXPENDITURE_CATEGORY_FLAG
, BASED_ON_LINE_ITEM
, PROJECT_ID
, AWARD_ID
, TASK_ID
, IGW_BUDGET_INTEGRATION.GET_OH_COST(LINE_ITEM_ID) OH_COST
, IGW_BUDGET_INTEGRATION.GET_EB_COST(LINE_ITEM_ID) EB_COST
FROM IGW_BUDGET_DETAILS
Columns
Name |
PROPOSAL_ID |
VERSION_ID |
BUDGET_PERIOD_ID |
LINE_ITEM_ID |
LINE_ITEM_COST |
EXPENDITURE_TYPE |
BUDGET_CATEGORY_CODE |
EXPENDITURE_CATEGORY_FLAG |
BASED_ON_LINE_ITEM |
PROJECT_ID |
AWARD_ID |
TASK_ID |
OH_COST |
EB_COST |