[Home] [Help]
View: GMS_REFERENCE_NUMBERS_V
View Text
SELECT R.AWARD_ID
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.CREATION_DATE
, R.CREATED_BY
, R.LAST_UPDATE_LOGIN
, R.TYPE
, R.VALUE
, R.REQUIRED_FLAG
, LP.MEANING
, R.ROWID
FROM GMS_REFERENCE_NUMBERS R
, GMS_LOOKUPS LP
WHERE LP.LOOKUP_TYPE = 'REFERENCE_NUMBER'
AND LP.LOOKUP_CODE = R.TYPE
Columns
Name |
AWARD_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
TYPE |
VALUE |
REQUIRED_FLAG |
TYPE_DIS |
ROW_ID |