[Home] [Help]
| Product: | IGW - Grants Proposal (Obsolete) |
|---|---|
| Description: | Views displays details about special reviews conducted for the proposal |
| Implementation/DBA Data: | Not implemented in this database |
SELECT P.PROPOSAL_ID
, P.PROPOSAL_NUMBER
, DECODE(H.SPECIAL_REVIEW_CODE
, '1'
, 'X'
, ' ')
, DECODE(H.SPECIAL_REVIEW_CODE
, '1'
, ' '
, 'X')
, DECODE(H.APPROVAL_TYPE_CODE
, 1
, 'X'
, ' ')
, DECODE(H.APPROVAL_TYPE_CODE
, 2
, 'X'
, ' ')
, DECODE(H.APPROVAL_TYPE_CODE
, 3
, 'X'
, ' ')
, DECODE(H.SPECIAL_REVIEW_TYPE
, 'F'
, 'X'
, ' ')
, DECODE(H.SPECIAL_REVIEW_TYPE
, 'E'
, 'X'
, ' ')
, H.APPROVAL_DATE
, DECODE(A.SPECIAL_REVIEW_CODE
, '2'
, 'X'
, ' ')
, DECODE(A.SPECIAL_REVIEW_CODE
, '2'
, ' '
, 'X')
, DECODE(A.APPROVAL_TYPE_CODE
, 1
, 'X'
, ' ')
, DECODE(A.APPROVAL_TYPE_CODE
, 2
, 'X'
, ' ')
, DECODE(A.APPROVAL_TYPE_CODE
, 3
, 'X'
, ' ')
, DECODE(A.SPECIAL_REVIEW_TYPE
, 'F'
, 'X'
, ' ')
, DECODE(A.SPECIAL_REVIEW_TYPE
, 'E'
, 'X'
, ' ')
, A.APPROVAL_DATE
FROM IGW_PROP_SPECIAL_REVIEWS H
, IGW_PROP_SPECIAL_REVIEWS A
, IGW_PROPOSALS_ALL P
WHERE H.SPECIAL_REVIEW_CODE(+) = '1'
AND A.SPECIAL_REVIEW_CODE(+) = '2'
AND A.PROPOSAL_ID(+) = P.PROPOSAL_ID
AND H.PROPOSAL_ID(+) = P.PROPOSAL_ID