VIEW: APPS.IGW_PRPO_SUBJECT_INFO_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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