VIEW: APPS.IGW_PRPO_OTHER_SUPPORT_V

Source

View Text - Preformatted

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, substrb(p.party_name,1,50) 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, hz_parties p, hz_cust_accounts c WHERE PPS.pi_person_id = PPX.person_id(+) and LKUP1.lookup_type(+) = 'IGW_SUPPORT_TYPES' and LKUP1.lookup_code(+) = PPS.support_type and p.party_id(+) = c.party_id and c.cust_account_id(+) = PPS.sponsor_id

View Text - HTML Formatted

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
, SUBSTRB(P.PARTY_NAME
, 1
, 50) 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
, HZ_PARTIES P
, HZ_CUST_ACCOUNTS C
WHERE PPS.PI_PERSON_ID = PPX.PERSON_ID(+)
AND LKUP1.LOOKUP_TYPE(+) = 'IGW_SUPPORT_TYPES'
AND LKUP1.LOOKUP_CODE(+) = PPS.SUPPORT_TYPE
AND P.PARTY_ID(+) = C.PARTY_ID
AND C.CUST_ACCOUNT_ID(+) = PPS.SPONSOR_ID