SELECT PR.PROPOSAL_NUMBER, PAR.RUN_NUMBER, PAR.RUN_ID, PR.PROPOSAL_ID, PAR.STATUS_CODE, PAR.STATUS_DATE from IGW_PROP_APPROVAL_RUNS PAR, IGW_PROPOSALS_ALL PR WHERE PR.proposal_id = PAR.proposal_id with read only
View Text - HTML Formatted
SELECT PR.PROPOSAL_NUMBER , PAR.RUN_NUMBER , PAR.RUN_ID , PR.PROPOSAL_ID , PAR.STATUS_CODE , PAR.STATUS_DATE FROM IGW_PROP_APPROVAL_RUNS PAR , IGW_PROPOSALS_ALL PR WHERE PR.PROPOSAL_ID = PAR.PROPOSAL_ID WITH READ ONLY