FND Design Data [Home] [Help]

Table: AS_LEAD_LINES_ALL

Product: AS - Sales Foundation
Description: Holds sales opportunity lines
Implementation/DBA Data: TableOSM.AS_LEAD_LINES_ALL
Primary Key: AS_LEAD_LINES_ALL_PK
  1. ColumnLEAD_LINE_ID
Primary Key: AS_LEAD_LINES_PK
  1. ColumnLEAD_LINE_ID
Primary Key: AS_LEAD_LINES_UK
  1. ColumnLEAD_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AS_LEAD_LINES_ALL FK Joins to TableAS_LEADS_ALL AS_LEAD_LINES_ALL.LEAD_ID
AS_LEAD_LINES_ALL FK Joins to TableMTL_SYSTEM_ITEMS_B AS_LEAD_LINES_ALL.INVENTORY_ITEM_ID
AS_LEAD_LINES_ALL.ORGANIZATION_ID
AS_LEAD_LINES_ALL FK Joins to TableAS_INTEREST_TYPES_B AS_LEAD_LINES_ALL.INTEREST_TYPE_ID
AS_LEAD_LINES_ALL FK Joins to TableAS_INTEREST_CODES_B AS_LEAD_LINES_ALL.PRIMARY_INTEREST_CODE_ID
AS_LEAD_LINES_ALL FK Joins to TableAS_INTEREST_CODES_B AS_LEAD_LINES_ALL.SECONDARY_INTEREST_CODE_ID
AS_LEAD_LINES_ALL FK Joins to TableAMS_SOURCE_CODES AS_LEAD_LINES_ALL.SOURCE_PROMOTION_ID
AS_LEAD_LINES_ALL FK Joins to TableAMS_ACT_OFFERS AS_LEAD_LINES_ALL.OFFER_ID
AS_LEAD_LINES_ALL FK Joins to TableAS_LEADS_ALL AS_LEAD_LINES_ALL.LEAD_ID
AS_LEAD_LINES_ALL FK Joins to TableMTL_SYSTEM_ITEMS_B AS_LEAD_LINES_ALL.INVENTORY_ITEM_ID
AS_LEAD_LINES_ALL.ORGANIZATION_ID
AS_LEAD_LINES_ALL FK Joins to TableAS_INTEREST_CODES_ALL AS_LEAD_LINES_ALL.PRIMARY_INTEREST_CODE_ID
AS_LEAD_LINES_ALL FK Joins to TableAS_INTEREST_CODES_ALL AS_LEAD_LINES_ALL.SECONDARY_INTEREST_CODE_ID
AS_LEAD_LINES_ALL FK Joins to TableAS_INTEREST_TYPES_ALL AS_LEAD_LINES_ALL.INTEREST_TYPE_ID
AS_LEAD_LINES_ALL FK Joins to TableAS_SALES_STAGES_ALL_B AS_LEAD_LINES_ALL.SALES_STAGE_ID
TableASO_QUOTE_RELATED_OBJECTS FK Joins to AS_LEAD_LINES_ALL ASO_QUOTE_RELATED_OBJECTS.OBJECT_ID
TableAS_LEAD_COMP_PRODUCTS FK Joins to AS_LEAD_LINES_ALL AS_LEAD_COMP_PRODUCTS.LEAD_LINE_ID
TableAS_LEAD_DECISION_FACTORS FK Joins to AS_LEAD_LINES_ALL AS_LEAD_DECISION_FACTORS.LEAD_LINE_ID
TableAS_OPP_COMPETING_PRODS FK Joins to AS_LEAD_LINES_ALL AS_OPP_COMPETING_PRODS.LEAD_LINE_ID
TableAS_SALES_CREDITS_DENORM FK Joins to AS_LEAD_LINES_ALL AS_SALES_CREDITS_DENORM.LEAD_LINE_ID
TableAS_SALES_CREDITS FK Joins to AS_LEAD_LINES_ALL AS_SALES_CREDITS.LEAD_LINE_ID
TableAS_SALES_LEAD_OPP_LINES FK Joins to AS_LEAD_LINES_ALL AS_SALES_LEAD_OPP_LINES.OPP_LINE_ID