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: ORDSYS.ORDDCM_PREFS_LOOKUP

Object Details

Object Name:	ORDDCM_PREFS_LOOKUP
Object Type:	TABLE
Owner:	ORDSYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: SYS_C00235843

PARAM_NAME

Unique Key: SYS_C00235844

SYS_NC0000900010$

Unique Key: SYS_C00235845

SYS_NC0000700008$

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00235843	NORMAL	UNIQUE	SYSTEM	PARAM_NAME
SYS_C00235844	NORMAL	UNIQUE	SYSTEM	VALID_STR_VALUES
SYS_C00235845	NORMAL	UNIQUE	SYSTEM	DEFAULT_STR_VALUES

Columns

Name	Datatype	Length	Mandatory
PARAM_NAME	VARCHAR2	(64)	Yes
PARAM_TYPE	VARCHAR2	(15)	Yes
MIN_VAL	NUMBER
MAX_VAL	NUMBER
DEFAULT_NUMBER_VAL	NUMBER
DEFAULT_STR_VAL	VARCHAR2	(1999)
DEFAULT_STR_VALUES	ORD_STR_LIST	(16)
VALID_STR_VALUES	ORD_STR_LIST	(16)
PARAM_DESC	VARCHAR2	(4000)

Query Text

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


SELECT PARAM_NAME
,      PARAM_TYPE
,      MIN_VAL
,      MAX_VAL
,      DEFAULT_NUMBER_VAL
,      DEFAULT_STR_VAL
,      DEFAULT_STR_VALUES
,      VALID_STR_VALUES
,      PARAM_DESC
FROM ORDSYS.ORDDCM_PREFS_LOOKUP;

Dependencies

[top of page]

ORDSYS.ORDDCM_PREFS_LOOKUP references the following:

ORDSYS: ORD_STR_LIST
SYS: STANDARD - show dependent code

ORDSYS.ORDDCM_PREFS_LOOKUP is not referenced by any database object