[Home] [Help]
View: IGWBV_GRANT_PROPOSAL_RATE
View Text
SELECT LKUP1.MEANING
, INS_RATES.FISCAL_YEAR
, LKUP2.MEANING
, INS_RATES.START_DATE
, INS_RATES.RATE
, INS_RATES.RATE_CLASS_ID
, INS_RATES.RATE_TYPE_ID
, INS_RATES.LAST_UPDATE_DATE
, INS_RATES.LAST_UPDATED_BY
, INS_RATES.CREATION_DATE
, INS_RATES.CREATED_BY
FROM IGW_INSTITUTE_RATES INS_RATES
, IGW_LOOKUPS_V LKUP1
, IGW_LOOKUPS_V LKUP2
WHERE LKUP1.LOOKUP_TYPE = 'IGW_ACTIVITY_TYPES'
AND LKUP1.LOOKUP_CODE = INS_RATES.ACTIVITY_TYPE_CODE
AND LKUP2.LOOKUP_TYPE = 'IGW_LOCATION'
AND LKUP2.LOOKUP_CODE = INS_RATES.LOCATION_CODE WITH READ ONLY
Columns
| Name |
| ACTIVITY_TYPE |
| FISCAL_YEAR |
| LOCATION |
| START_DATE |
| RATE |
| RATE_CLASS_ID |
| RATE_TYPE_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
APPS.IGWBV_GRANT_PROPOSAL_RATE