VIEW: APPS.IGWBV_GRANT_PROPOSAL_OVRD_RATE

Source

View Text - Preformatted

SELECT PR.PROPOSAL_NUMBER, PRATES.VERSION_ID, PRATES.FISCAL_YEAR, LKUP2.meaning, LKUP1.meaning, PRATES.START_DATE, PRATES.APPLICABLE_RATE, PRATES.INSTITUTE_RATE, PR.PROPOSAL_ID, PRATES.RATE_CLASS_ID, PRATES.RATE_TYPE_ID, PRATES.LAST_UPDATE_DATE, PRATES.LAST_UPDATED_BY, PRATES.CREATION_DATE, PRATES.CREATED_BY from IGW_PROP_RATES PRATES, IGW_PROPOSALS_ALL PR, IGW_LOOKUPS_V LKUP1 , IGW_LOOKUPS_V LKUP2 WHERE PR.proposal_id = PRATES.proposal_id and LKUP1.lookup_type = 'IGW_ACTIVITY_TYPES' and LKUP1.lookup_code = PRATES.activity_type_code and LKUP2.lookup_type = 'IGW_LOCATION' and LKUP2.lookup_code = PRATES.location_code with read only

View Text - HTML Formatted

SELECT PR.PROPOSAL_NUMBER
, PRATES.VERSION_ID
, PRATES.FISCAL_YEAR
, LKUP2.MEANING
, LKUP1.MEANING
, PRATES.START_DATE
, PRATES.APPLICABLE_RATE
, PRATES.INSTITUTE_RATE
, PR.PROPOSAL_ID
, PRATES.RATE_CLASS_ID
, PRATES.RATE_TYPE_ID
, PRATES.LAST_UPDATE_DATE
, PRATES.LAST_UPDATED_BY
, PRATES.CREATION_DATE
, PRATES.CREATED_BY
FROM IGW_PROP_RATES PRATES
, IGW_PROPOSALS_ALL PR
, IGW_LOOKUPS_V LKUP1
, IGW_LOOKUPS_V LKUP2
WHERE PR.PROPOSAL_ID = PRATES.PROPOSAL_ID
AND LKUP1.LOOKUP_TYPE = 'IGW_ACTIVITY_TYPES'
AND LKUP1.LOOKUP_CODE = PRATES.ACTIVITY_TYPE_CODE
AND LKUP2.LOOKUP_TYPE = 'IGW_LOCATION'
AND LKUP2.LOOKUP_CODE = PRATES.LOCATION_CODE WITH READ ONLY