[Home] [Help]
View: IGWBV_GRANT_PROPOSAL_PERS_ASGN
View Text
SELECT PR.PROPOSAL_NUMBER
, PER.PERSON_SEQUENCE
, LKUP1.MEANING
, PER.KEY_PERSON_FLAG
, PER.PERCENT_EFFORT
, PER.PI_FLAG
, PR.PROPOSAL_ID
, PER.PERSON_ID
, PER.PERSON_ORGANIZATION_ID
, PER.LAST_UPDATE_DATE
, PER.LAST_UPDATED_BY
, PER.CREATION_DATE
, PER.CREATED_BY
FROM IGW_PROP_PERSONS PER
, IGW_PROPOSALS_ALL PR
, IGW_LOOKUPS_V LKUP1
WHERE PR.PROPOSAL_ID = PER.PROPOSAL_ID
AND LKUP1.LOOKUP_TYPE = 'IGW_PROPOSAL_ROLE_TYPES'
AND LKUP1.LOOKUP_CODE = PER.PROPOSAL_ROLE_CODE WITH READ ONLY
Columns
Name |
PROPOSAL_NUMBER |
PERSON_SEQUENCE |
PROPOSAL_ROLE |
KEY_PERSON_FLAG |
EFFORT_PERCENT |
PI_FLAG |
PROPOSAL_ID |
PERSON_ID |
PERSON_ORGANIZATION_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |