eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: AS_LEADS_ALL

Product:	AS - Sales Foundation
Description:	Holds sales opportunities
Implementation/DBA Data:	OSM.AS_LEADS_ALL

Primary Key: AS_LEADS_ALL_PK

LEAD_ID

Primary Key: AS_LEADS_PK

LEAD_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AS_LEADS_ALL	HZ_PARTIES	AS_LEADS_ALL.CUSTOMER_ID
AS_LEADS_ALL	AS_FORECAST_PROB_ALL_B	AS_LEADS_ALL.WIN_PROBABILITY
AS_LEADS_ALL	HZ_PARTY_SITES	AS_LEADS_ALL.ADDRESS_ID
AS_LEADS_ALL	JTF_RS_RESOURCE_EXTNS	AS_LEADS_ALL.OWNER_SALESFORCE_ID
AS_LEADS_ALL	JTF_RS_GROUPS_B	AS_LEADS_ALL.OWNER_SALES_GROUP_ID
AS_LEADS_ALL	AS_SALES_STAGES_ALL_B	AS_LEADS_ALL.SALES_STAGE_ID
AS_LEADS_ALL	AMS_SOURCE_CODES	AS_LEADS_ALL.SOURCE_PROMOTION_ID
AS_LEADS_ALL	AS_STATUSES_B	AS_LEADS_ALL.STATUS
AS_LEADS_ALL	HZ_PARTIES	AS_LEADS_ALL.CLOSE_COMPETITOR_ID
AS_LEADS_ALL	FND_CURRENCIES	AS_LEADS_ALL.CURRENCY_CODE
AS_LEADS_ALL	AS_SALES_METHODOLOGY_B	AS_LEADS_ALL.SALES_METHODOLOGY_ID
AS_LEADS_ALL	RA_CUSTOMERS	AS_LEADS_ALL.CUSTOMER_ID
AS_LEADS_ALL	RA_ADDRESSES_ALL	AS_LEADS_ALL.ADDRESS_ID
AS_LEADS_ALL	FND_CURRENCIES	AS_LEADS_ALL.CURRENCY_CODE
AS_LEADS_ALL	AS_SALES_STAGES_ALL_B	AS_LEADS_ALL.SALES_STAGE_ID
AS_LEADS_ALL	%	AS_LEADS_ALL.INITIATING_CONTACT_ID
ASO_QUOTE_RELATED_OBJECTS	AS_LEADS_ALL	ASO_QUOTE_RELATED_OBJECTS.OBJECT_ID
AS_ACCESSES_ALL_ALL	AS_LEADS_ALL	AS_ACCESSES_ALL_ALL.LEAD_ID
AS_ACCESSES_ALL_ALL	AS_LEADS_ALL	AS_ACCESSES_ALL_ALL.LEAD_ID
AS_CHANGED_ACCOUNTS_ALL	AS_LEADS_ALL	AS_CHANGED_ACCOUNTS_ALL.LEAD_ID
AS_INTERESTS_ALL	AS_LEADS_ALL	AS_INTERESTS_ALL.LEAD_ID
AS_INTERESTS_ALL	AS_LEADS_ALL	AS_INTERESTS_ALL.LEAD_ID
AS_LEAD_COMPETITORS	AS_LEADS_ALL	AS_LEAD_COMPETITORS.LEAD_ID
AS_LEAD_COMP_PRODUCTS	AS_LEADS_ALL	AS_LEAD_COMP_PRODUCTS.LEAD_ID
AS_LEAD_CONTACTS_ALL	AS_LEADS_ALL	AS_LEAD_CONTACTS_ALL.LEAD_ID
AS_LEAD_CONTACTS_ALL	AS_LEADS_ALL	AS_LEAD_CONTACTS_ALL.LEAD_ID
AS_LEAD_LINES_ALL	AS_LEADS_ALL	AS_LEAD_LINES_ALL.LEAD_ID
AS_LEAD_LINES_ALL	AS_LEADS_ALL	AS_LEAD_LINES_ALL.LEAD_ID
AS_LEAD_LOG	AS_LEADS_ALL	AS_LEAD_LOG.LEAD_ID
AS_LEADS_LOG	AS_LEADS_ALL	AS_LEADS_LOG.LEAD_ID
AS_LEAD_OBSTACLES	AS_LEADS_ALL	AS_LEAD_OBSTACLES.LEAD_ID
AS_LEAD_ORDERS	AS_LEADS_ALL	AS_LEAD_ORDERS.LEAD_ID
AS_OPP_WORKSHEET_LINES	AS_LEADS_ALL	AS_OPP_WORKSHEET_LINES.LEAD_ID
AS_SALES_CREDITS_DENORM	AS_LEADS_ALL	AS_SALES_CREDITS_DENORM.LEAD_ID
AS_SALES_CREDITS	AS_LEADS_ALL	AS_SALES_CREDITS.LEAD_ID
AS_SALES_LEAD_OPPORTUNITY	AS_LEADS_ALL	AS_SALES_LEAD_OPPORTUNITY.OPPORTUNITY_ID
AS_TERR_RESOURCES_TMP	AS_LEADS_ALL	AS_TERR_RESOURCES_TMP.LEAD_ID
JTF_NOTES_B	AS_LEADS_ALL	JTF_NOTES_B.SOURCE_OBJECT_ID
JTF_NOTE_CONTEXTS	AS_LEADS_ALL	JTF_NOTE_CONTEXTS.NOTE_CONTEXT_TYPE_ID
PV_REFERRALS_B	AS_LEADS_ALL	PV_REFERRALS_B.ENTITY_ID_LINKED_TO
PV_ENTY_ATTR_VALUES	AS_LEADS_ALL	PV_ENTY_ATTR_VALUES.ENTITY_ID
PV_LEAD_ASSIGNMENTS	AS_LEADS_ALL	PV_LEAD_ASSIGNMENTS.LEAD_ID
PV_LEAD_PSS_LINES	AS_LEADS_ALL	PV_LEAD_PSS_LINES.LEAD_ID
PV_LEAD_WORKFLOWS	AS_LEADS_ALL	PV_LEAD_WORKFLOWS.LEAD_ID