[Home] [Help]
View: IGW_INSTITUTE_RATES_V
View Text
SELECT IIR.ROWID
, IIR.RATE_CLASS_ID
, IIR.RATE_TYPE_ID
, IIR.ACTIVITY_TYPE_CODE
, FL1.MEANING
, IIR.FISCAL_YEAR
, IIR.LOCATION_CODE
, FL2.MEANING LOCATION
, IIR.START_DATE
, IIR.RATE
, IIR.LAST_UPDATE_DATE
, IIR.LAST_UPDATED_BY
, IIR.CREATION_DATE
, IIR.CREATED_BY
, IIR.LAST_UPDATE_LOGIN
FROM IGW_INSTITUTE_RATES IIR
, FND_LOOKUPS FL1
, FND_LOOKUPS FL2
WHERE FL1.LOOKUP_TYPE = 'IGW_ACTIVITY_TYPES'
AND FL1.LOOKUP_CODE = IIR.ACTIVITY_TYPE_CODE
AND FL2.LOOKUP_TYPE = 'IGW_LOCATION'
AND FL2.LOOKUP_CODE = IIR.LOCATION_CODE
Columns
Name |
ROW_ID |
RATE_CLASS_ID |
RATE_TYPE_ID |
ACTIVITY_TYPE_CODE |
ACTIVITY_TYPE |
FISCAL_YEAR |
LOCATION_CODE |
LOCATION |
START_DATE |
RATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |