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.CE_SO_FC_ORDERS_V

Object Details

Object Name:	CE_SO_FC_ORDERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CE_SO_FC_ORDERS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

The CE_SO_FC_ORDERS_V view contains sales orders for forecasting. The Cash Forecasting program uses this view to generate projected cash inflow amounts from the uninvoiced sales orders. Based on the forecast template definition and forecast submission criteria, the Cash Forecasting program selects only the applicable sales orders from this view to determine forecast amounts.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_ID	NUMBER			Organization identifier
CURRENCY_CODE	VARCHAR2	(15)		Currency code of the order
AMOUNT	NUMBER			Order amount
BASE_AMOUNT	NUMBER			Order amount in the base currency
DATE_ORDERED	DATE			Date ordered
DATE_REQUESTED	DATE			Date requested
BOOKED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the order has been booked or not
CONVERSION_TYPE_CODE	VARCHAR2	(30)		Exchange rate type
CONVERSION_DATE	VARCHAR2	(9)		Exchange rate date
CONVERSION_RATE	NUMBER			Exchange rate
COMMITMENT_ID	NUMBER			Commitment identifier
PROFILE_CLASS_ID	NUMBER	(15)	Yes	Standard Credit Profiles that can be assigned to a specific customer
PROJECT_ID	NUMBER			Identifier for project used to build default Accounting Flexfield
ORDER_TYPE_ID	NUMBER		Yes	Order type identifier
ORDER_NUMBER	NUMBER		Yes	Sales Order Number
LINE_NUMBER	NUMBER		Yes	Sales Order Line Number
LINE_FLOW_STATUS_CODE	VARCHAR2	(30)		Sales Order Line Flow Status
PROFILE_CLASS	VARCHAR2	(30)	Yes	Profile Class
REFERENCE_ID	NUMBER		Yes	Reference identifier

Query Text

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


SELECT ORG_ID
,      CURRENCY_CODE
,      AMOUNT
,      BASE_AMOUNT
,      DATE_ORDERED
,      DATE_REQUESTED
,      BOOKED_FLAG
,      CONVERSION_TYPE_CODE
,      CONVERSION_DATE
,      CONVERSION_RATE
,      COMMITMENT_ID
,      PROFILE_CLASS_ID
,      PROJECT_ID
,      ORDER_TYPE_ID
,      ORDER_NUMBER
,      LINE_NUMBER
,      LINE_FLOW_STATUS_CODE
,      PROFILE_CLASS
,      REFERENCE_ID
FROM APPS.CE_SO_FC_ORDERS_V;

Dependencies

[top of page]

APPS.CE_SO_FC_ORDERS_V references the following:

APPS: HZ_CUSTOMER_PROFILES; HZ_CUST_PROFILE_CLASSES; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL

APPS.CE_SO_FC_ORDERS_V is referenced by following:

APPS: CE_FC_OEO_DISC_V