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

VIEW: APPS.CE_AS_FC_SALES_FCST_V

Object Details
Object Name: CE_AS_FC_SALES_FCST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CE_AS_FC_SALES_FCST_V
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.CE_AS_FC_SALES_FCST_V references the following:

SchemaAPPS
SynonymAS_LEADS_ALL
SynonymAS_LEAD_LINES_ALL
SynonymAS_QUOTES_ALL
APPS.CE_AS_FC_SALES_FCST_V is referenced by following:

SchemaAPPS
ViewCE_FC_ASF_DISC_V