[Home] [Help]
View: IGWFV_GRNT_PRPSL_PERS_BIOSKTCH
View Text
SELECT PAPF.FULL_NAME
, 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
, PER_ALL_PEOPLE_F PAPF
WHERE LKUP1.LOOKUP_CODE = BIOSKETCH.BIOSKETCH_TYPE
AND LKUP1.LOOKUP_TYPE = 'IGW_BIOSKETCH_TYPES'
AND PAPF.PERSON_ID = BIOSKETCH.PERSON_ID
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE
AND PAPF.EFFECTIVE_END_DATE WITH READ ONLY
Columns
Name |
PERSON_FULL_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 |