VIEW: APPS.IGW_PROP_SPECIAL_REVIEWS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'