[Home] [Help]
View: IGW_PRPO_BIOSKETCH_V
Product: | IGW - Grants Proposal |
Description: | View displays a person's biosketch information |
Implementation/DBA Data: |
APPS.IGW_PRPO_BIOSKETCH_V
|
View Text
SELECT PPPB.PROPOSAL_ID
, PPB.PERSON_ID
, PPB.PARTY_ID
, PPB.BIOSKETCH_TYPE
, VAL.MEANING
, PPB.LINE_DESCRIPTION
, KEY.KEY_PERSON_FLAG
FROM IGW_PROP_PERSON_BIOSKETCH PPPB
, IGW_PERSON_BIOSKETCH PPB
, IGW_PROP_PERSONS KEY
, IGW_LOOKUPS_V VAL
WHERE PPPB.PERSON_BIOSKETCH_ID = PPB.PERSON_BIOSKETCH_ID
AND KEY.PERSON_ID = PPB.PERSON_ID
AND KEY.PROPOSAL_ID = PPPB.PROPOSAL_ID
AND PPB.ENABLE_FLAG = 'Y'
AND PPPB.SHOW_FLAG = 'Y'
AND VAL.LOOKUP_CODE = PPB.BIOSKETCH_TYPE
AND VAL.LOOKUP_TYPE = 'IGW_BIOSKETCH_TYPES' UNION SELECT PPPB.PROPOSAL_ID
, PPB.PERSON_ID
, PPB.PARTY_ID
, PPB.BIOSKETCH_TYPE
, VAL.MEANING
, PPB.LINE_DESCRIPTION
, KEY.KEY_PERSON_FLAG
FROM IGW_PROP_PERSON_BIOSKETCH PPPB
, IGW_PERSON_BIOSKETCH PPB
, IGW_PROP_PERSONS KEY
, IGW_LOOKUPS_V VAL
WHERE PPPB.PERSON_BIOSKETCH_ID = PPB.PERSON_BIOSKETCH_ID
AND KEY.PERSON_PARTY_ID = PPB.PARTY_ID
AND KEY.PERSON_ID IS NULL
AND KEY.PROPOSAL_ID = PPPB.PROPOSAL_ID
AND PPB.ENABLE_FLAG = 'Y'
AND PPPB.SHOW_FLAG = 'Y'
AND VAL.LOOKUP_CODE = PPB.BIOSKETCH_TYPE
AND VAL.LOOKUP_TYPE = 'IGW_BIOSKETCH_TYPES' ORDER BY 2
, 4
Columns
Name |
PROPOSAL_ID |
PERSON_ID |
PARTY_ID |
BIOSKETCH_TYPE_CODE |
BIOSKETCH_TYPE |
BIOSKETCH_DESCRIPTION |
KEY_PERSON_FLAG |