Product: | IGW - Grants Proposal |
---|---|
Description: | View displays details of human subjects involved in the proposal |
Implementation/DBA Data: | APPS.IGW_PRPO_SUBJECT_INFO_V |
SELECT ST.PROPOSAL_ID
, ST.STUDY_TITLE
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '1'
, '1')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '2'
, '1')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '3'
, '1')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '4'
, '1')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '5'
, '1')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '6'
, '1')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '1'
, '2')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '2'
, '2')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '3'
, '2')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '4'
, '2')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '5'
, '2')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '6'
, '2')
FROM IGW_STUDY_TITLES ST