FND Design Data [Home] [Help]

Table: AS_SALES_LEADS

Product: AS - Sales Foundation
Description: Holds sales leads
Implementation/DBA Data: TableOSM.AS_SALES_LEADS
Primary Key: AS_SALES_LEADS_PK
  1. ColumnSALES_LEAD_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AS_SALES_LEADS FK Joins to TableAS_STATUSES_B AS_SALES_LEADS.STATUS_CODE
AS_SALES_LEADS FK Joins to TableHZ_PARTY_SITES AS_SALES_LEADS.ADDRESS_ID
AS_SALES_LEADS FK Joins to TableHZ_PARTIES AS_SALES_LEADS.INCUMBENT_PARTNER_PARTY_ID
AS_SALES_LEADS FK Joins to TableHZ_PARTY_SITES AS_SALES_LEADS.ADDRESS_ID
AS_SALES_LEADS FK Joins to TableHZ_CONTACT_POINTS AS_SALES_LEADS.PRIMARY_CONTACT_PHONE_ID
AS_SALES_LEADS FK Joins to TableHZ_PARTIES AS_SALES_LEADS.PRIMARY_CNT_PERSON_PARTY_ID
AS_SALES_LEADS FK Joins to TableJTF_RS_RESOURCE_EXTNS AS_SALES_LEADS.ASSIGN_TO_SALESFORCE_ID
AS_SALES_LEADS FK Joins to TableAS_SALES_LEAD_RANKS_B AS_SALES_LEADS.LEAD_RANK_ID
AS_SALES_LEADS FK Joins to TableAMS_ACT_OFFERS AS_SALES_LEADS.OFFER_ID
AS_SALES_LEADS FK Joins to TableHZ_PARTIES AS_SALES_LEADS.CUSTOMER_ID
AS_SALES_LEADS FK Joins to Table% AS_SALES_LEADS.CUSTOMER_ID
AS_SALES_LEADS FK Joins to TableAS_SALES_LEAD_SCORECARDS AS_SALES_LEADS.SCORECARD_ID
AS_SALES_LEADS FK Joins to TableJTF_RS_GROUPS_B AS_SALES_LEADS.ASSIGN_SALES_GROUP_ID
TableAML_INTERACTION_LEADS FK Joins to AS_SALES_LEADS AML_INTERACTION_LEADS.SALES_LEAD_ID
TableASO_QUOTE_RELATED_OBJECTS FK Joins to AS_SALES_LEADS ASO_QUOTE_RELATED_OBJECTS.OBJECT_ID
TableAS_ACCESSES_ALL_ALL FK Joins to AS_SALES_LEADS AS_ACCESSES_ALL_ALL.SALES_LEAD_ID
TableAS_CHANGED_ACCOUNTS_ALL FK Joins to AS_SALES_LEADS AS_CHANGED_ACCOUNTS_ALL.SALES_LEAD_ID
TableAS_SALES_LEAD_CONTACTS FK Joins to AS_SALES_LEADS AS_SALES_LEAD_CONTACTS.SALES_LEAD_ID
TableAS_SALES_LEADS_LOG FK Joins to AS_SALES_LEADS AS_SALES_LEADS_LOG.SALES_LEAD_ID
TableAS_SALES_LEAD_CONTACTS FK Joins to AS_SALES_LEADS AS_SALES_LEAD_CONTACTS.SALES_LEAD_ID
TableAS_SALES_LEAD_LINES FK Joins to AS_SALES_LEADS AS_SALES_LEAD_LINES.SALES_LEAD_ID
TableAS_SALES_LEAD_OPPORTUNITY FK Joins to AS_SALES_LEADS AS_SALES_LEAD_OPPORTUNITY.SALES_LEAD_ID
TableIGR_I_APPL_ALL FK Joins to AS_SALES_LEADS IGR_I_APPL_ALL.SALES_LEAD_ID
TableIGS_RC_I_APPL_ALL FK Joins to AS_SALES_LEADS IGS_RC_I_APPL_ALL.SALES_LEAD_ID
TableJTF_NOTES_B FK Joins to AS_SALES_LEADS JTF_NOTES_B.SOURCE_OBJECT_ID
TableJTF_NOTE_CONTEXTS FK Joins to AS_SALES_LEADS JTF_NOTE_CONTEXTS.NOTE_CONTEXT_TYPE_ID
TablePV_REFERRALS_B FK Joins to AS_SALES_LEADS PV_REFERRALS_B.ENTITY_ID_LINKED_TO
TablePV_LEAD_PSS_LINES FK Joins to AS_SALES_LEADS PV_LEAD_PSS_LINES.LEAD_ID