VIEW: APPS.IGWFV_GRNT_PRPSL_PERS_OTHR_SUP

Source

View Text - Preformatted

SELECT PPS.PROP_PERSON_SUPPORT_ID, PR.PROPOSAL_NUMBER, PAPF.full_name, PAPF2.FULL_NAME, substrb(p.party_name,1,50) customer_name, '_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', 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 , PER_ALL_PEOPLE_F PAPF, PER_ALL_PEOPLE_F PAPF2, HZ_PARTIES P, HZ_CUST_ACCOUNTS C WHERE PR.proposal_id = PPS.proposal_id and trunc(sysdate) between PAPF.effective_start_date and PAPF.effective_end_date and PAPF.person_id = PPS.person_id and PAPF2.person_id = PPS.pi_person_id and trunc(sysdate) between PAPF2.effective_start_date and PAPF2.effective_end_date and c.party_id = p.party_id and c.cust_account_id = PPS.sponsor_id with read only

View Text - HTML Formatted

SELECT PPS.PROP_PERSON_SUPPORT_ID
, PR.PROPOSAL_NUMBER
, PAPF.FULL_NAME
, PAPF2.FULL_NAME
, SUBSTRB(P.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, '_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'
, 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
, PER_ALL_PEOPLE_F PAPF
, PER_ALL_PEOPLE_F PAPF2
, HZ_PARTIES P
, HZ_CUST_ACCOUNTS C
WHERE PR.PROPOSAL_ID = PPS.PROPOSAL_ID
AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE
AND PAPF.EFFECTIVE_END_DATE
AND PAPF.PERSON_ID = PPS.PERSON_ID
AND PAPF2.PERSON_ID = PPS.PI_PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PAPF2.EFFECTIVE_START_DATE
AND PAPF2.EFFECTIVE_END_DATE
AND C.PARTY_ID = P.PARTY_ID
AND C.CUST_ACCOUNT_ID = PPS.SPONSOR_ID WITH READ ONLY