VIEW: APPS.IGW_BUDGET_COSTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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