Product: | AS - Sales Foundation |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT '_LA:COM.COMPETITOR_CODE:AS_LOOKUPS:COMPETITOR:MEANING'
, COM.COMPETITOR
, COM.PRODUCTS
, COM.COMMENTS
, '_DF:AS:AS_LEAD_COMPETITORS:COM' -- RESOLVE FK
, LEAD.LEAD_NUMBER
, LEAD.DESCRIPTION
, CUST.CUSTOMER_NAME -- ID
, COM.LEAD_COMPETITOR_ID
, COM.LEAD_ID
, COM.COMPETITOR_ID -- WHO
, COM.LAST_UPDATE_DATE
, COM.LAST_UPDATED_BY
, COM.CREATION_DATE
, COM.CREATED_BY
FROM RA_CUSTOMERS CUST
, AS_LEADS_ALL LEAD
, AS_LEAD_COMPETITORS COM
WHERE COM.COMPETITOR_ID = CUST.CUSTOMER_ID (+)
AND COM.LEAD_ID = LEAD.LEAD_ID WITH READ ONLY