VIEW: APPS.IGWBV_GRNT_PRPSL_SPCL_RVW

Source

View Text - Preformatted

SELECT pr. proposal_number , lkup1.meaning , lkup2.meaning , '_LA:rv.approval_type_code:igw_lookups_v:IGW_REVIEW_APPROVAL_TYPES:meaning' , rv.PROTOCOL_NUMBER , rv.APPLICATION_DATE , rv.APPROVAL_DATE , rv.COMMENTS , rv.PROPOSAL_ID , rv.LAST_UPDATE_DATE , rv.LAST_UPDATED_BY , rv.CREATION_DATE , rv.CREATED_BY from igw_proposals_all pr, igw_prop_special_Reviews rv, igw_lookups_v lkup1, igw_lookups_v lkup2 WHERE pr.proposal_id = rv.proposal_id and lkup1.lookup_type = 'IGW_SPECIAL_REVIEWS' and lkup1.lookup_code = rv.special_review_code and lkup2.lookup_code(+) = 'IGW_SPECIAL_REVIEW_TYPES' and lkup2.lookup_code(+) = rv.special_review_type with read only

View Text - HTML Formatted

SELECT PR. PROPOSAL_NUMBER
, LKUP1.MEANING
, LKUP2.MEANING
, '_LA:RV.APPROVAL_TYPE_CODE:IGW_LOOKUPS_V:IGW_REVIEW_APPROVAL_TYPES:MEANING'
, RV.PROTOCOL_NUMBER
, RV.APPLICATION_DATE
, RV.APPROVAL_DATE
, RV.COMMENTS
, RV.PROPOSAL_ID
, RV.LAST_UPDATE_DATE
, RV.LAST_UPDATED_BY
, RV.CREATION_DATE
, RV.CREATED_BY
FROM IGW_PROPOSALS_ALL PR
, IGW_PROP_SPECIAL_REVIEWS RV
, IGW_LOOKUPS_V LKUP1
, IGW_LOOKUPS_V LKUP2
WHERE PR.PROPOSAL_ID = RV.PROPOSAL_ID
AND LKUP1.LOOKUP_TYPE = 'IGW_SPECIAL_REVIEWS'
AND LKUP1.LOOKUP_CODE = RV.SPECIAL_REVIEW_CODE
AND LKUP2.LOOKUP_CODE(+) = 'IGW_SPECIAL_REVIEW_TYPES'
AND LKUP2.LOOKUP_CODE(+) = RV.SPECIAL_REVIEW_TYPE WITH READ ONLY