DBA Data[Home] [Help]

VIEW: APPS.IGWBV_GRNT_PRPSL_PERS_PRF_ASGN

Source

View Text - Preformatted

SELECT PR.PROPOSAL_NUMBER, 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_PROPOSALS_ALL PR WHERE PR.proposal_id = PPD.proposal_id with read only
View Text - HTML Formatted

SELECT PR.PROPOSAL_NUMBER
, 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_PROPOSALS_ALL PR
WHERE PR.PROPOSAL_ID = PPD.PROPOSAL_ID WITH READ ONLY