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