Product: | IGW - Grants Proposal |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGWFV_GRNT_PRPSL_SPCL_RVW |
SELECT PR. PROPOSAL_NUMBER
, LKUP1.MEANING
, LKUP2.MEANING
, '_LA:RV.APPROVAL_TYPE_CODE:IGW_LOOKUPS_V:IGW_REVIEW_APPROVAL_TYPES:MEANING'
, RV.PROTOCOL_NUMBER
, RV.APPLICATION_DATE
, RV.APPROVAL_DATE
, RV.COMMENTS
, RV.PROPOSAL_ID
, RV.LAST_UPDATE_DATE
, RV.LAST_UPDATED_BY
, RV.CREATION_DATE
, RV.CREATED_BY
FROM IGW_PROPOSALS_ALL PR
, IGW_PROP_SPECIAL_REVIEWS RV
, IGW_LOOKUPS_V LKUP1
, IGW_LOOKUPS_V LKUP2
WHERE PR.PROPOSAL_ID = RV.PROPOSAL_ID
AND LKUP1.LOOKUP_TYPE = 'IGW_SPECIAL_REVIEWS'
AND LKUP1.LOOKUP_CODE = RV.SPECIAL_REVIEW_CODE
AND LKUP2.LOOKUP_CODE(+) = 'IGW_SPECIAL_REVIEW_TYPES'
AND LKUP2.LOOKUP_CODE(+) = RV.SPECIAL_REVIEW_TYPE WITH READ ONLY