VIEW: APPS.IGWBV_GRANT_PRPSL_SUPPRT_TEXT

Source

View Text - Preformatted

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

View Text - HTML Formatted

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