[Home] [Help]
View: IGWBV_GRANT_PROPOSAL_KEYWORD
View Text
SELECT PR.PROPOSAL_NUMBER
, SC.PROPOSAL_ID
, SC.SCIENCE_CODE
, SC.LAST_UPDATE_DATE
, SC.LAST_UPDATED_BY
, SC.CREATION_DATE
, SC.CREATED_BY
FROM IGW_PROP_SCIENCE_CODES SC
, IGW_PROPOSALS_ALL PR
WHERE PR.PROPOSAL_ID = SC.PROPOSAL_ID WITH READ ONLY
Columns
Name |
PROPOSALNUMBER |
PROPOSAL_ID |
SCIENCE_CODE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |