VIEW: APPS.AS_SALES_TEAM_PTR_V

Source

View Text - Preformatted

SELECT acc.rowid ,acc.access_id ,acc.last_update_date ,acc.last_updated_by ,acc.creation_date ,acc.created_by ,acc.last_update_login ,acc.request_id ,acc.program_application_id ,acc.program_id ,acc.program_update_date ,acc.access_type ,acc.freeze_flag ,acc.reassign_flag ,acc.team_leader_flag ,acc.customer_id ,acc.address_id ,acc.partner_customer_id ,acc.partner_address_id ,acc.salesforce_id ,acc.created_person_id ,acc.lead_id ,acc.freeze_date ,acc.reassign_reason ,acc.downloadable_flag ,acc.attribute_category ,acc.attribute1 ,acc.attribute2 ,acc.attribute3 ,acc.attribute4 ,acc.attribute5 ,acc.attribute6 ,acc.attribute7 ,acc.attribute8 ,acc.attribute9 ,acc.attribute10 ,acc.attribute11 ,acc.attribute12 ,acc.attribute13 ,acc.attribute14 ,acc.attribute15 ,cust.party_name ,cust.party_number ,acc.salesforce_role_code ,aslkp2.meaning ,acc.salesforce_relationship_code ,aslkp3.meaning ,acc.reassign_request_date ,acc.reassign_requested_person_id ,acc.partner_cont_party_id ,loc.city ,loc.postal_code ,loc.state ,loc.province ,loc.county ,loc.country ,loc.address1 ,loc.address2 ,loc.address3 ,loc.address4 ,cust.party_type ,acc.sales_lead_id from hz_parties cust , as_accesses_all acc , hz_party_sites site , hz_locations loc , as_lookups aslkp2 , as_lookups aslkp3 where acc.partner_customer_id = cust.party_id and acc.partner_address_id = site.party_site_id(+) and site.location_id = loc.location_id(+) and acc.salesforce_role_code = aslkp2.lookup_code(+) and aslkp2.lookup_type(+) = 'ROLE_TYPE' and acc.salesforce_relationship_code = aslkp3.lookup_code(+) and aslkp3.lookup_type(+) = 'SALESFORCE_RELATIONSHIP'

View Text - HTML Formatted

SELECT ACC.ROWID
, ACC.ACCESS_ID
, ACC.LAST_UPDATE_DATE
, ACC.LAST_UPDATED_BY
, ACC.CREATION_DATE
, ACC.CREATED_BY
, ACC.LAST_UPDATE_LOGIN
, ACC.REQUEST_ID
, ACC.PROGRAM_APPLICATION_ID
, ACC.PROGRAM_ID
, ACC.PROGRAM_UPDATE_DATE
, ACC.ACCESS_TYPE
, ACC.FREEZE_FLAG
, ACC.REASSIGN_FLAG
, ACC.TEAM_LEADER_FLAG
, ACC.CUSTOMER_ID
, ACC.ADDRESS_ID
, ACC.PARTNER_CUSTOMER_ID
, ACC.PARTNER_ADDRESS_ID
, ACC.SALESFORCE_ID
, ACC.CREATED_PERSON_ID
, ACC.LEAD_ID
, ACC.FREEZE_DATE
, ACC.REASSIGN_REASON
, ACC.DOWNLOADABLE_FLAG
, ACC.ATTRIBUTE_CATEGORY
, ACC.ATTRIBUTE1
, ACC.ATTRIBUTE2
, ACC.ATTRIBUTE3
, ACC.ATTRIBUTE4
, ACC.ATTRIBUTE5
, ACC.ATTRIBUTE6
, ACC.ATTRIBUTE7
, ACC.ATTRIBUTE8
, ACC.ATTRIBUTE9
, ACC.ATTRIBUTE10
, ACC.ATTRIBUTE11
, ACC.ATTRIBUTE12
, ACC.ATTRIBUTE13
, ACC.ATTRIBUTE14
, ACC.ATTRIBUTE15
, CUST.PARTY_NAME
, CUST.PARTY_NUMBER
, ACC.SALESFORCE_ROLE_CODE
, ASLKP2.MEANING
, ACC.SALESFORCE_RELATIONSHIP_CODE
, ASLKP3.MEANING
, ACC.REASSIGN_REQUEST_DATE
, ACC.REASSIGN_REQUESTED_PERSON_ID
, ACC.PARTNER_CONT_PARTY_ID
, LOC.CITY
, LOC.POSTAL_CODE
, LOC.STATE
, LOC.PROVINCE
, LOC.COUNTY
, LOC.COUNTRY
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, CUST.PARTY_TYPE
, ACC.SALES_LEAD_ID
FROM HZ_PARTIES CUST
, AS_ACCESSES_ALL ACC
, HZ_PARTY_SITES SITE
, HZ_LOCATIONS LOC
, AS_LOOKUPS ASLKP2
, AS_LOOKUPS ASLKP3
WHERE ACC.PARTNER_CUSTOMER_ID = CUST.PARTY_ID
AND ACC.PARTNER_ADDRESS_ID = SITE.PARTY_SITE_ID(+)
AND SITE.LOCATION_ID = LOC.LOCATION_ID(+)
AND ACC.SALESFORCE_ROLE_CODE = ASLKP2.LOOKUP_CODE(+)
AND ASLKP2.LOOKUP_TYPE(+) = 'ROLE_TYPE'
AND ACC.SALESFORCE_RELATIONSHIP_CODE = ASLKP3.LOOKUP_CODE(+)
AND ASLKP3.LOOKUP_TYPE(+) = 'SALESFORCE_RELATIONSHIP'