Product: | IGW - Grants Proposal |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGWBV_GRNT_PRPSL_PERS_OTHR_SUP |
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