View: IGW_BUDGET_COSTS_V

Product:	IGW - Grants Proposal
Description:	View displays direct cost and total cost of the budget
Implementation/DBA Data:	APPS.IGW_BUDGET_COSTS_V

View Text

SELECT P.PROPOSAL_ID
, BV.VERSION_ID
, P.PROPOSAL_START_DATE
, P.PROPOSAL_END_DATE
, TRUNC(MONTHS_BETWEEN(P.PROPOSAL_END_DATE
, P.PROPOSAL_START_DATE))
, BV.TOTAL_COST
, BV.TOTAL_DIRECT_COST
, BV.TOTAL_INDIRECT_COST
, BP.TOTAL_COST INITIAL_TOTAL_COST
, BP.TOTAL_DIRECT_COST INITIAL_DIRECT_COST
, BP.TOTAL_INDIRECT_COST INITIAL_INDIRECT_COST
FROM IGW_PROPOSALS_ALL P
, IGW_BUDGETS BV
, IGW_BUDGET_PERIODS BP
WHERE BV.PROPOSAL_ID = P.PROPOSAL_ID
AND BV.FINAL_VERSION_FLAG = 'Y'
AND BP.PROPOSAL_ID = P.PROPOSAL_ID
AND BP.VERSION_ID = BV.VERSION_ID
AND BP.BUDGET_PERIOD_ID = 1

Columns