[Home] [Help]
View: IGW_PRPO_SPECIAL_REVIEWS_V
| Product: | IGW - Grants Proposal (Obsolete) |
|---|
| Description: | View displays details of special reviews conducted for the proposal |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
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
| Name |
| PROPOSAL_ID |
| REVIEW_SUBJECT |
| REVIEW_COVERAGE |
| APPROVAL_STATUS |
| APPROVAL_DATE |
| PROTOCOL_NUMBER |
| APPLICATION_DATE |