[Home] [Help]
View: IGWFV_GRNT_PRPSL_PERS_PRF_ASGN
View Text
SELECT PR.PROPOSAL_NUMBER
, PAPF.FULL_NAME
, LKUP1.MEANING
, PD.LINE_DESCRIPTION
, PD.ENABLE_FLAG
, PPD.SHOW_FLAG
, PPD.LINE_SEQUENCE
, PR.PROPOSAL_ID
, PPD.PERSON_BIOSKETCH_ID
, PPD.LAST_UPDATE_DATE
, PPD.LAST_UPDATED_BY
, PPD.CREATION_DATE
, PPD.CREATED_BY
FROM IGW_PROP_PERSON_BIOSKETCH PPD
, IGW_PERSON_BIOSKETCH PD
, IGW_PROPOSALS_ALL PR
, PER_ALL_PEOPLE_F PAPF
, IGW_LOOKUPS_V LKUP1
WHERE PR.PROPOSAL_ID = PPD.PROPOSAL_ID
AND PD.PERSON_BIOSKETCH_ID = PPD.PERSON_BIOSKETCH_ID
AND PAPF.PERSON_ID = PD.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE
AND PAPF.EFFECTIVE_END_DATE
AND PD.BIOSKETCH_TYPE = LKUP1.LOOKUP_CODE
AND LKUP1.LOOKUP_TYPE = 'IGW_BIOSKETCH_TYPES' WITH READ ONLY
Columns
Name |
PROPOSAL_NUMBER |
PERSON_NAME |
BIOSKETCH_TYPE |
BIOSKETCH_LINE |
ENABLE_FLAG |
SHOW_FLAG |
LINE_SEQUENCE |
PROPOSAL_ID |
PERSON_BIOSKETCH_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |