[Home] [Help] [Dependency Information]
Object Name: | AMS_LEAD_ACCOUNTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_LEAD_ACCOUNTS_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
APPS.AMS_LEAD_ACCOUNTS_V is not referenced by any database object
|
|
|