FND Design Data [Home] [Help]

Table: AS_LEAD_COMP_PRODUCTS

Product: AS - Sales Foundation
Description: Holds competitor products
Implementation/DBA Data: TableOSM.AS_LEAD_COMP_PRODUCTS
Primary Key: AS_LEAD_COMP_PRODUCTS_PK
  1. ColumnLEAD_COMPETITOR_PROD_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AS_LEAD_COMP_PRODUCTS FK Joins to TableAS_LEADS_ALL AS_LEAD_COMP_PRODUCTS.LEAD_ID
AS_LEAD_COMP_PRODUCTS FK Joins to TableAS_LEAD_LINES_ALL AS_LEAD_COMP_PRODUCTS.LEAD_LINE_ID
AS_LEAD_COMP_PRODUCTS FK Joins to TableAMS_COMPETITOR_PRODUCTS_B AS_LEAD_COMP_PRODUCTS.COMPETITOR_PRODUCT_ID
AS_LEAD_COMP_PRODUCTS FK Joins to TableHZ_PARTIES AS_LEAD_COMP_PRODUCTS.COMPETITOR_ID