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

VIEW: APPS.CE_SO_FC_ORDERS_NO_TERMS_V

Object Details
Object Name: CE_SO_FC_ORDERS_NO_TERMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CE_SO_FC_ORDERS_NO_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.


Forecasting source - sales orders. This view retrieves sales orders for forecasting where no payment terms are available but 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_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
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 (40)
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_NO_TERMS_V;

Dependencies

[top of page]

APPS.CE_SO_FC_ORDERS_NO_TERMS_V references the following:

SchemaAPPS
SynonymHZ_CUSTOMER_PROFILES
SynonymHZ_CUST_PROFILE_CLASSES
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL

APPS.CE_SO_FC_ORDERS_NO_TERMS_V is not referenced by any database object