VIEW: APPS.IGWBV_GRNT_PRPSL_PERS_OTHR_SUP

Source

View Text - Preformatted

SELECT PR.PROPOSAL_NUMBER, '_LA:pps.support_type:igw_lookups_v:IGW_SUPPORT_TYPES:meaning', PPS.PROPOSAL_AWARD_NUMBER, PPS.PROPOSAL_AWARD_TITLE, PPS.START_DATE, PPS.END_DATE, PPS.PERCENT_EFFORT, PPS.ANNUAL_DIRECT_COST, PPS.TOTAL_COST, PPS.PROJECT_LOCATION, PPS.CALENDAR_START_DATE, PPS.CALENDAR_END_DATE, PPS.ACADEMIC_START_DATE, PPS.ACADEMIC_END_DATE, PPS.SUMMER_START_DATE, PPS.SUMMER_END_DATE, PPS.MAJOR_GOALS, PPS.OVERLAP , '_DF:IGW:IGW_PERSON_SUPPORT_DESC_FLEX:pps', PPS.PROP_PERSON_SUPPORT_ID, PR.PROPOSAL_ID, PPS.PERSON_ID, PPS.PI_PERSON_ID, PPS.SPONSOR_ID, PPS.LAST_UPDATE_DATE, PPS.LAST_UPDATED_BY, PPS.CREATION_DATE, PPS.CREATED_BY from IGW_PROP_PERSON_SUPPORT PPS, IGW_PROPOSALS_ALL PR WHERE PR.proposal_id = PPS.proposal_id with read only

View Text - HTML Formatted

SELECT PR.PROPOSAL_NUMBER
, '_LA:PPS.SUPPORT_TYPE:IGW_LOOKUPS_V:IGW_SUPPORT_TYPES:MEANING'
, PPS.PROPOSAL_AWARD_NUMBER
, PPS.PROPOSAL_AWARD_TITLE
, PPS.START_DATE
, PPS.END_DATE
, PPS.PERCENT_EFFORT
, PPS.ANNUAL_DIRECT_COST
, PPS.TOTAL_COST
, PPS.PROJECT_LOCATION
, PPS.CALENDAR_START_DATE
, PPS.CALENDAR_END_DATE
, PPS.ACADEMIC_START_DATE
, PPS.ACADEMIC_END_DATE
, PPS.SUMMER_START_DATE
, PPS.SUMMER_END_DATE
, PPS.MAJOR_GOALS
, PPS.OVERLAP
, '_DF:IGW:IGW_PERSON_SUPPORT_DESC_FLEX:PPS'
, PPS.PROP_PERSON_SUPPORT_ID
, PR.PROPOSAL_ID
, PPS.PERSON_ID
, PPS.PI_PERSON_ID
, PPS.SPONSOR_ID
, PPS.LAST_UPDATE_DATE
, PPS.LAST_UPDATED_BY
, PPS.CREATION_DATE
, PPS.CREATED_BY
FROM IGW_PROP_PERSON_SUPPORT PPS
, IGW_PROPOSALS_ALL PR
WHERE PR.PROPOSAL_ID = PPS.PROPOSAL_ID WITH READ ONLY