[Home] [Help] [Dependency Information]
Object Name: | CE_AS_FC_SALES_FCST_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CE.CE_AS_FC_SALES_FCST_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The CE_AS_FC_SALES_FCST_V view contains sales leads that have not yet been ordered or invoiced. The Cash Forecasting program uses this view to generate projected cash inflow amounts from sales leads.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BASE_AMOUNT | NUMBER | Sales lead amount in the functional currency | ||
AMOUNT | NUMBER | Sales lead amount | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency code of the sales lead | |
TRX_DATE | DATE | Transaction date | ||
WIN_PROBABILITY | NUMBER | Win probability of the sales lead | ||
CHANNEL_CODE | VARCHAR2 | (30) | Sales channel for the sales lead | |
STATUS_CODE | VARCHAR2 | (30) | Yes | Sales lead status |
SALES_STAGE_ID | NUMBER | Sales stage identifier | ||
ORG_ID | NUMBER | Organization identifier | ||
LEAD_NUMBER | VARCHAR2 | (30) | Yes | Lead Number |
REFERENCE_ID | NUMBER | Yes | Reference identifier |
Cut, paste (and edit) the following text to query this object:
SELECT BASE_AMOUNT
, AMOUNT
, CURRENCY_CODE
, TRX_DATE
, WIN_PROBABILITY
, CHANNEL_CODE
, STATUS_CODE
, SALES_STAGE_ID
, ORG_ID
, LEAD_NUMBER
, REFERENCE_ID
FROM APPS.CE_AS_FC_SALES_FCST_V;
|
|
|