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