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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AMS_LEAD_ACCOUNTS_V

Object Details

Object Name:	AMS_LEAD_ACCOUNTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_LEAD_ACCOUNTS_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
LEAD_ID	NUMBER		Yes
DESCRIPTION	VARCHAR2	(240)
SALES_STAGE	VARCHAR2	(60)
WIN_PROBABILITY	VARCHAR2	(41)
OPP_STATUS	VARCHAR2	(30)	Yes
TOTAL_AMOUNT	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
CHANNEL_CODE	VARCHAR2	(30)
CLOSE_REASON	VARCHAR2	(30)
INITIATIVES	VARCHAR2	(150)
FORECAST_SPONSOR	VARCHAR2	(150)
SEGMENTED	VARCHAR2	(150)
SOLUTION_TYPE	VARCHAR2	(150)
PROJECT_NAME_NUMBER	VARCHAR2	(150)
ACTION_TO_CLOSE	VARCHAR2	(150)
LEAD_SOURCE	VARCHAR2	(150)
ORDER_NUMBER	VARCHAR2	(150)
INTERNAL_PROCESS_STATUS	VARCHAR2	(150)
NEW_ACCOUNT	VARCHAR2	(150)
OPP_INTEREST_TYPE	VARCHAR2	(80)	Yes
OPP_PRIMARY_INTEREST	VARCHAR2	(181)
OPP_SECONDARY_INTEREST	VARCHAR2	(282)
ADDRESS_ID	NUMBER
CUSTOMER_ID	NUMBER		Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LEAD_ID
,      DESCRIPTION
,      SALES_STAGE
,      WIN_PROBABILITY
,      OPP_STATUS
,      TOTAL_AMOUNT
,      CURRENCY_CODE
,      CHANNEL_CODE
,      CLOSE_REASON
,      INITIATIVES
,      FORECAST_SPONSOR
,      SEGMENTED
,      SOLUTION_TYPE
,      PROJECT_NAME_NUMBER
,      ACTION_TO_CLOSE
,      LEAD_SOURCE
,      ORDER_NUMBER
,      INTERNAL_PROCESS_STATUS
,      NEW_ACCOUNT
,      OPP_INTEREST_TYPE
,      OPP_PRIMARY_INTEREST
,      OPP_SECONDARY_INTEREST
,      ADDRESS_ID
,      CUSTOMER_ID
FROM APPS.AMS_LEAD_ACCOUNTS_V;

Dependencies

[top of page]

APPS.AMS_LEAD_ACCOUNTS_V references the following:

APPS: AS_INTERESTS_ALL; AS_INTEREST_CODES_VL; AS_INTEREST_TYPES_VL; AS_LEADS_ALL; AS_LEAD_LINES_ALL; AS_SALES_STAGES_ALL_VL

APPS.AMS_LEAD_ACCOUNTS_V is not referenced by any database object