FND Design Data [Home] [Help]

View: ASFV_SALES_COMPETITORS

Product: AS - Sales Foundation
Description:
Implementation/DBA Data: Not implemented in this database
View Text

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

Columns

Name
"_LA:COMPETITOR_CODE"
COMPETITOR
PRODUCTS
COMMENTS
"_DF"
LEAD_NUMBER
LEAD_DESCRIPTION
COMPETITOR_NAME
LEAD_COMPETITOR_ID
LEAD_ID
COMPETITOR_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY