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_TERMS_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

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

This view retrieves sales orders for forecasting where payment terms are available and the option of including payment terms in the forecast calculation is checked. The Cash Forecasting program uses this view in conjunction with CE_SO_FC_ORDERS_NO_TERMS_V to generate projected cash inflow amounts from sales orders.

[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
TERM_DUE_DATE	DATE			Payment terms fixed due date
TERM_DUE_DAYS	NUMBER			Number of days until due
TERM_DUE_DAY_OF_MONTH	NUMBER			Day of month when due
TERM_DUE_MONTHS_FORWARD	NUMBER			Number of months until due
RELATIVE_AMOUNT	NUMBER		Yes	Amount due this installment relative to the base amount
TERM_ID	NUMBER			Terms 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	VARCHAR2	(122)		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
,      TERM_DUE_DATE
,      TERM_DUE_DAYS
,      TERM_DUE_DAY_OF_MONTH
,      TERM_DUE_MONTHS_FORWARD
,      RELATIVE_AMOUNT
,      TERM_ID
,      ORDER_NUMBER
,      LINE_NUMBER
,      LINE_FLOW_STATUS_CODE
,      PROFILE_CLASS
,      REFERENCE_ID
FROM APPS.CE_SO_FC_ORDERS_TERMS_V;

Dependencies

[top of page]

APPS.CE_SO_FC_ORDERS_TERMS_V references the following:

APPS: HZ_CUSTOMER_PROFILES; HZ_CUST_PROFILE_CLASSES; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; RA_TERMS_LINES

APPS.CE_SO_FC_ORDERS_TERMS_V is referenced by following:

APPS: CE_FC_OEO_DISC_V