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