View: IGW_PRPO_SPECIAL_REVIEWS_V

Product:	IGW - Grants Proposal
Description:	View displays details of special reviews conducted for the proposal
Implementation/DBA Data:	APPS.IGW_PRPO_SPECIAL_REVIEWS_V

View Text

SELECT PPS.PROPOSAL_ID
, LKUP1.MEANING
, LKUP3.MEANING
, LKUP2.MEANING
, PPS.APPROVAL_DATE
, PPS.PROTOCOL_NUMBER
, PPS.APPLICATION_DATE
FROM IGW_PROP_SPECIAL_REVIEWS PPS
, IGW_LOOKUPS_V LKUP1
, IGW_LOOKUPS_V LKUP2
, IGW_LOOKUPS_V LKUP3
WHERE PPS.SPECIAL_REVIEW_CODE = LKUP1.LOOKUP_CODE(+)
AND PPS.APPROVAL_TYPE_CODE = LKUP2.LOOKUP_CODE(+)
AND LKUP2.LOOKUP_TYPE(+) = 'IGW_REVIEW_APPROVAL_TYPES'
AND LKUP1.LOOKUP_TYPE(+) = 'IGW_SPECIAL_REVIEWS'AND LKUP3.LOOKUP_TYPE(+) = 'IGW_SPECIAL_REVIEW_TYPES'AND PPS.SPECIAL_REVIEW_TYPE = LKUP3.LOOKUP_CODE(+)

Columns