[Home] [Help]
View: IGWFV_GRANT_PROPOSAL_RATE
View Text
SELECT CLASS.DESCRIPTION
, TYPE.DESCRIPTION
, 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
, IGW_RATE_CLASSES CLASS
, IGW_RATE_TYPES TYPE
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
AND INS_RATES.RATE_CLASS_ID = CLASS.RATE_CLASS_ID
AND INS_RATES.RATE_TYPE_ID = TYPE.RATE_TYPE_ID WITH READ ONLY
Columns
| Name |
| RATE_CLASS_DESCRIPTION |
| RATE_TYPE_DESCRIPTION |
| 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.IGWFV_GRANT_PROPOSAL_RATE