DBA Data[Home] [Help]

VIEW: APPS.IGWBV_GRNT_PRPSL_PERS_BIOSKTCH

Source

View Text - Preformatted

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
View Text - HTML Formatted

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