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]

TABLE: ONT.OE_SYSTEM_PARAMETERS_ALL

Object Details

Object Name:	OE_SYSTEM_PARAMETERS_ALL
Object Type:	TABLE
Owner:	ONT
FND Design Data:	ONT.OE_SYSTEM_PARAMETERS_ALL
Subobject Name:
Status:	VALID

This table is used for storing all system parameter information. Currently the only system parameter in Order Management being Item Validation Organization, this table stores the information of Validation Organization for different operating units.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_ID	NUMBER			This column stores Operating Unit Information.
CREATION_DATE	DATE		Yes	Date of creation of this record.
CREATED_BY	NUMBER		Yes	User who created this record.
LAST_UPDATE_DATE	DATE		Yes	Date when this record was last updated.
LAST_UPDATED_BY	NUMBER		Yes	User who last updated this record.
LAST_UPDATE_LOGIN	NUMBER			Login used during last update.
MASTER_ORGANIZATION_ID	NUMBER		Yes	Item Validation Organization for this operating unit.
CONTEXT	VARCHAR2	(30)		Descriptive Flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment.
CUSTOMER_RELATIONSHIPS_FLAG	VARCHAR2	(1)		To drive customer association in AR.
PROCESS_ORDERS_SORTED_BY	VARCHAR2	(30)		used to select orders for automatic credit checking
OE_BALANCE_CONV_TYPE	VARCHAR2	(30)		used in multi-currency credit checking conversions
OE_BALANCE_CONV_DATE	VARCHAR2	(30)		used in multi-currency credit checking conversions
AR_BALANCE_CONV_TYPE	VARCHAR2	(30)		used in multi-currency credit checking conversions
AR_BALANCE_CONV_DATE	VARCHAR2	(30)		used in multi-currency credit checking conversions
CREDIT_HOLD_LEVEL_CODE	VARCHAR2	(30)		Credit hold level code.
AUDIT_TRAIL_ENABLE_FLAG	VARCHAR2	(1)		Audittrail enable flag
COMPUTE_MARGIN_FLAG	VARCHAR2	(1)		Margin Calculation Method
FREIGHT_RATING_ENABLED_FLAG	VARCHAR2	(1)		This flag indicates if the user can perform Get Freight Rates for Order action from Sales Order Form.
FTE_SHIP_METHOD_ENABLED_FLAG	VARCHAR2	(1)		This flag indicates if the user can perform Get Ship Method for an Order action from Sales Order form and also using public process order API e.g. Order Import

Query Text

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


SELECT ORG_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      MASTER_ORGANIZATION_ID
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CUSTOMER_RELATIONSHIPS_FLAG
,      PROCESS_ORDERS_SORTED_BY
,      OE_BALANCE_CONV_TYPE
,      OE_BALANCE_CONV_DATE
,      AR_BALANCE_CONV_TYPE
,      AR_BALANCE_CONV_DATE
,      CREDIT_HOLD_LEVEL_CODE
,      AUDIT_TRAIL_ENABLE_FLAG
,      COMPUTE_MARGIN_FLAG
,      FREIGHT_RATING_ENABLED_FLAG
,      FTE_SHIP_METHOD_ENABLED_FLAG
FROM ONT.OE_SYSTEM_PARAMETERS_ALL;

Dependencies

[top of page]

ONT.OE_SYSTEM_PARAMETERS_ALL does not reference any database object

ONT.OE_SYSTEM_PARAMETERS_ALL is not referenced by any database object