[Home] [Help]
View: IGWBV_GRNT_PRPSL_PERS_BIOSKTCH
View Text
SELECT LKUP1.MEANING
, BIOSKETCH.LINE_SEQUENCE
, BIOSKETCH.LINE_DESCRIPTION
, BIOSKETCH.ENABLE_FLAG
, BIOSKETCH.PERSON_BIOSKETCH_ID
, BIOSKETCH.PERSON_ID
, BIOSKETCH.LAST_UPDATE_DATE
, BIOSKETCH.LAST_UPDATED_BY
, BIOSKETCH.CREATION_DATE
, BIOSKETCH.CREATED_BY
FROM IGW_PERSON_BIOSKETCH BIOSKETCH
, IGW_LOOKUPS_V LKUP1
WHERE LKUP1.LOOKUP_CODE = BIOSKETCH.BIOSKETCH_TYPE
AND LKUP1.LOOKUP_TYPE = 'IGW_BIOSKETCH_TYPES' WITH READ ONLY
Columns
Name |
BIOSKETCH_TYPE |
BIOSKETCH_LINE_SEQUENCE |
BIOSKETCH_LINE |
ENABLE_FLAG |
PERSON_BIOSKETCH_ID |
PERSON_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |