[Home] [Help]
View: IGW_OH_TEMP_V
Product: | IGW - Grants Proposal |
Description: | View to display overhead amounts for a particular proposal, budget version, budget period and rate class |
Implementation/DBA Data: |
APPS.IGW_OH_TEMP_V
|
View Text
SELECT PBD.PROPOSAL_ID
, PBD.VERSION_ID
, BUDGET_PERIOD_ID
, SUM(CALCULATED_COST) CALCULATED_COST
, PBD.RATE_CLASS_ID
, IRC.DESCRIPTION
FROM IGW_BUDGET_DETAILS_CAL_AMTS PBD
, IGW_RATE_TYPES PRT
, IGW_RATE_CLASSES IRC
WHERE PBD.RATE_CLASS_ID = PRT.RATE_CLASS_ID
AND PBD.RATE_TYPE_ID = PRT.RATE_TYPE_ID AND PRT.RATE_CLASS_ID = IRC.RATE_CLASS_ID GROUP BY PBD.PROPOSAL_ID
, PBD.VERSION_ID
, PBD.BUDGET_PERIOD_ID
, PBD.RATE_CLASS_ID
, IRC.DESCRIPTION
Columns
Name |
PROPOSAL_ID |
VERSION_ID |
BUDGET_PERIOD_ID |
CALCULATED_COST |
RATE_CLASS_ID |
DESCRIPTION |