[Home] [Help]
View: IGWBV_GRANT_PRPSL_SUPPRT_TEXT
View Text
SELECT PR.PROPOSAL_NUMBER
, PR.PROPOSAL_ID
, AB.ABSTRACT_TYPE_CODE
, LKUP1.MEANING
, AB.ABSTRACT
, AB.ABSTRACT_TYPE
, '_DF:IGW:IGW_PROP_ABSTRACTS_DESC_FLEX:AB'
, AB.LAST_UPDATE_DATE
, AB.LAST_UPDATED_BY
, AB.CREATION_DATE
, AB.CREATED_BY
FROM IGW_PROPOSALS_ALL PR
, IGW_PROP_ABSTRACTS AB
, IGW_LOOKUPS_V LKUP1
WHERE AB.PROPOSAL_ID = PR.PROPOSAL_ID
AND LKUP1.LOOKUP_TYPE = AB.ABSTRACT_TYPE
AND AB.ABSTRACT_TYPE_CODE = LKUP1.LOOKUP_CODE WITH READ ONLY
Columns
| Name |
| PROPOSAL_NUMBER |
| PROPOSAL_ID |
| ABSTRACT_CODE |
| ABSTRACT_TYPE |
| ABSTRACT |
| ABSTRACT_CATEGORY |
| "_DF" |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
APPS.IGWBV_GRANT_PRPSL_SUPPRT_TEXT