VIEW: APPS.IGW_TRANSFERABLE_BUDGETS_V

Source

View Text - Preformatted

SELECT pb.version_id , pb.proposal_id from IGW_budgets pb , IGW_proposals pp WHERE pb.proposal_id = pp.proposal_id and pp.proposal_status = 'A'

View Text - HTML Formatted

SELECT PB.VERSION_ID
, PB.PROPOSAL_ID
FROM IGW_BUDGETS PB
, IGW_PROPOSALS PP
WHERE PB.PROPOSAL_ID = PP.PROPOSAL_ID
AND PP.PROPOSAL_STATUS = 'A'