FND Design Data [Home] [Help]

Table: PV_LEAD_ASSIGNMENTS

Product: PV - Partner Management
Description: Lead assignments
Implementation/DBA Data: TablePV.PV_LEAD_ASSIGNMENTS
Primary Key: PV_LEAD_ASSIGNMENTS_PK
  1. ColumnLEAD_ASSIGNMENT_ID
Primary Key: PV_LEAD_ASSIGNMENTS_UK1
  1. ColumnWF_ITEM_KEY
  2. ColumnWF_ITEM_TYPE
Foreign Keys
Table
Foreign Table Foreign Key Column
PV_LEAD_ASSIGNMENTS FK Joins to TableHZ_PARTIES PV_LEAD_ASSIGNMENTS.PARTNER_ID
PV_LEAD_ASSIGNMENTS FK Joins to TableAS_LEADS_ALL PV_LEAD_ASSIGNMENTS.LEAD_ID
PV_LEAD_ASSIGNMENTS FK Joins to TableJTF_RS_RESOURCE_EXTNS PV_LEAD_ASSIGNMENTS.CM_ID
PV_LEAD_ASSIGNMENTS FK Joins to TableHZ_PARTIES PV_LEAD_ASSIGNMENTS.RELATED_PARTY_ID
TablePV_ASSIGNMENT_LOGS FK Joins to PV_LEAD_ASSIGNMENTS PV_ASSIGNMENT_LOGS.LEAD_ASSIGNMENT_ID
TablePV_PARTY_NOTIFICATIONS FK Joins to PV_LEAD_ASSIGNMENTS PV_PARTY_NOTIFICATIONS.LEAD_ASSIGNMENT_ID