VIEW: APPS.IGW_SPECIAL_REVIEWS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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