View: IGW_SPECIAL_REVIEWS_V

Product:	IGW - Grants Proposal
Description:	Views displays details about special reviews conducted for the proposal
Implementation/DBA Data:	APPS.IGW_SPECIAL_REVIEWS_V

View Text

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

Columns