Product: | IGW - Grants Proposal |
---|---|
Description: | 10SC Only |
Implementation/DBA Data: | APPS.IGW_PROP_SPECIAL_REVIEWS_V |
SELECT S.ROWID
, S.PROPOSAL_ID
, S.SPECIAL_REVIEW_CODE
, L1.MEANING SPECIAL_REVIEW_DESC
, S.SPECIAL_REVIEW_TYPE
, L2.MEANING SPECIAL_REVIEW_TYPE_DESC
, S.APPROVAL_TYPE_CODE
, L3.MEANING APPROVAL_TYPE_DESC
, S.PROTOCOL_NUMBER
, S.APPLICATION_DATE
, S.APPROVAL_DATE
, S.COMMENTS
, S.LAST_UPDATE_DATE
, S.LAST_UPDATED_BY
, S.CREATION_DATE
, S.CREATED_BY
, S.LAST_UPDATE_LOGIN
FROM IGW_PROP_SPECIAL_REVIEWS S
, FND_LOOKUPS L1
, FND_LOOKUPS L2
, FND_LOOKUPS L3
WHERE L1.LOOKUP_CODE = S.SPECIAL_REVIEW_CODE
AND L1.LOOKUP_TYPE = 'IGW_SPECIAL_REVIEWS'
AND L2.LOOKUP_CODE(+) = S.SPECIAL_REVIEW_TYPE
AND L2.LOOKUP_TYPE(+) = 'IGW_SPECIAL_REVIEW_TYPES'
AND L3.LOOKUP_CODE(+) = S.APPROVAL_TYPE_CODE
AND L3.LOOKUP_TYPE(+) = 'IGW_REVIEW_APPROVAL_TYPES'