Product: | AS - Sales Foundation |
---|---|
Description: | Partners from salesforce view |
Implementation/DBA Data: | Not implemented in this database |
SELECT SALE.SALESFORCE_ID
, SALE.LAST_UPDATE_DATE
, SALE.LAST_UPDATED_BY
, SALE.CREATION_DATE
, SALE.CREATED_BY
, SALE.LAST_UPDATE_LOGIN
, SALE.START_DATE_ACTIVE
, SALE.END_DATE_ACTIVE
, SALE.EMPLOYEE_PERSON_ID
, SALE.PARTNER_CUSTOMER_ID
, ADDR.CITY
, ADDR.ADDRESS1
, SALE.PARTNER_ADDRESS_ID
, SALE.ATTRIBUTE_CATEGORY
, SALE.ATTRIBUTE1
, SALE.ATTRIBUTE2
, SALE.ATTRIBUTE3
, SALE.ATTRIBUTE4
, SALE.ATTRIBUTE5
, SALE.ATTRIBUTE6
, SALE.ATTRIBUTE7
, SALE.ATTRIBUTE8
, SALE.ATTRIBUTE9
, SALE.ATTRIBUTE10
, SALE.ATTRIBUTE11
, SALE.ATTRIBUTE12
, SALE.ATTRIBUTE13
, SALE.ATTRIBUTE14
, SALE.ATTRIBUTE15
, CUST.CUSTOMER_NAME
, SALE.TYPE
, PEOPLE.FIRST_NAME
, PEOPLE.LAST_NAME
FROM AS_SALESFORCE_V SALE
, AS_PARTY_CUSTOMERS_V CUST
, AS_PARTY_ADDRESSES_V ADDR
, PER_ALL_PEOPLE_F PEOPLE
WHERE SALE.PARTNER_ADDRESS_ID = ADDR.ADDRESS_ID
AND SALE.MEMBER_FLAG = 'Y'
AND ADDR.CUSTOMER_ID = CUST.CUSTOMER_ID
AND SALE.TYPE = 'PARTNER'
AND SALE.EMPLOYEE_PERSON_ID = PEOPLE.PERSON_ID(+)
AND TRUNC(SYSDATE) BETWEEN PEOPLE.EFFECTIVE_START_DATE(+)
AND PEOPLE.EFFECTIVE_END_DATE(+)