Product: | IGW - Grants Proposal |
---|---|
Description: | View displays details of other sources of support that are pending or available for personnel on the proposal |
Implementation/DBA Data: | APPS.IGW_PRPO_OTHER_SUPPORT_V |
SELECT PPS.PROPOSAL_ID
, PPS.PERSON_ID
, PPS.PARTY_ID
, LKUP1.MEANING
, PPS.PROPOSAL_AWARD_NUMBER
, PPS.PROPOSAL_AWARD_TITLE
, PPS.ANNUAL_DIRECT_COST
, PPS.TOTAL_COST
, PPS.PERCENT_EFFORT
, RAC.CUSTOMER_NAME
, PPS.MAJOR_GOALS
, PPX.LAST_NAME
, PPX.FIRST_NAME
, PPX.MIDDLE_NAMES
, PPS.PROJECT_LOCATION
, PPS.START_DATE
, PPS.END_DATE
, PPS.OVERLAP
, PPS.ATTRIBUTE_CATEGORY
, PPS.ATTRIBUTE1
, PPS.ATTRIBUTE2
, PPS.ATTRIBUTE3
, PPS.ATTRIBUTE4
, PPS.ATTRIBUTE5
, PPS.ATTRIBUTE6
, PPS.ATTRIBUTE7
, PPS.ATTRIBUTE8
, PPS.ATTRIBUTE9
, PPS.ATTRIBUTE10
, PPS.ATTRIBUTE11
, PPS.ATTRIBUTE12
, PPS.ATTRIBUTE13
, PPS.ATTRIBUTE14
, PPS.ATTRIBUTE15
FROM IGW_PROP_PERSON_SUPPORT PPS
, PER_PEOPLE_X PPX
, IGW_LOOKUPS_V LKUP1
, RA_CUSTOMERS RAC
WHERE PPS.PI_PERSON_ID = PPX.PERSON_ID(+)
AND LKUP1.LOOKUP_TYPE(+) = 'IGW_SUPPORT_TYPES'
AND LKUP1.LOOKUP_CODE(+) = PPS.SUPPORT_TYPE
AND RAC.CUSTOMER_ID(+) = PPS.SPONSOR_ID