Product: | AS - Sales Foundation |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT '_LA:SF.TYPE:AS_LOOKUPS:SALESFORCE_TYPE:MEANING'
, SF.STATUS_CODE
, SF.CLIENT_NUMBER
, '_DF:AS:AS_SALESFORCE:SF' -- RESOLVE FK
, GRP.NAME
, PER.FIRST_NAME
, PER.LAST_NAME
, CUST.CUSTOMER_NAME
, ADDR.CITY
, ADDR.COUNTRY
, CONT.FIRST_NAME
, CONT.LAST_NAME -- ID
, SF.SALESFORCE_ID
, SF.EMPLOYEE_PERSON_ID
, SF.SALES_GROUP_ID
, SF.PARTNER_CUSTOMER_ID
, SF.PARTNER_ADDRESS_ID
, SF.PARTNER_CONTACT_ID -- WHO
, SF.LAST_UPDATE_DATE
, SF.LAST_UPDATED_BY
, SF.CREATION_DATE
, SF.CREATED_BY
FROM PER_ALL_PEOPLE_F PER
, RA_CUSTOMERS CUST
, RA_ADDRESSES_ALL ADDR
, RA_CONTACTS CONT
, AS_SALES_GROUPS GRP
, AS_SALESFORCE SF
WHERE SF.EMPLOYEE_PERSON_ID = PER.PERSON_ID (+)
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE (+)
AND NVL(PER.EFFECTIVE_END_DATE (+)
, TRUNC(SYSDATE))
AND SF.PARTNER_CUSTOMER_ID = CUST.CUSTOMER_ID (+)
AND SF.PARTNER_ADDRESS_ID = ADDR.ADDRESS_ID (+)
AND SF.PARTNER_CONTACT_ID = CONT.CONTACT_ID (+) AND SF.SALES_GROUP_ID = GRP.SALES_GROUP_ID (+) WITH READ ONLY