[Home] [Help] [Dependency Information]

TABLE: ORDSYS.ORDDCM_CT_PRED

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: ORDDCM_CT_PRED_PK

1. PID

Indexes

Index	Type	Uniqueness	Tablespace	Column
ORDDCM_CT_PRED_PK	NORMAL	UNIQUE	SYSTEM	PID
ORDDCM_CT_P_FPID_IDX	NORMAL	NONUNIQUE	SYSTEM	FPID
ORDDCM_CT_P_REF_IDX	NORMAL	NONUNIQUE	SYSTEM	REF_PID

Foreign Keys

Table		Foreign Table	Foreign Key Column
ORDDCM_CT_PRED		ORDDCM_CT_PRED	ORDDCM_CT_PRED REF_PID
ORDDCM_CT_PRED		ORDDCM_CT_PRED	ORDDCM_CT_PRED FPID
ORDDCM_CT_ACTION		ORDDCM_CT_PRED	ORDDCM_CT_ACTION PID
ORDDCM_CT_PRED		ORDDCM_CT_PRED	ORDDCM_CT_PRED FPID
ORDDCM_CT_PRED		ORDDCM_CT_PRED	ORDDCM_CT_PRED REF_PID
ORDDCM_CT_PRED_OPRD		ORDDCM_CT_PRED	ORDDCM_CT_PRED_OPRD PID
ORDDCM_CT_PRED_PAR		ORDDCM_CT_PRED	ORDDCM_CT_PRED_PAR PID
ORDDCM_CT_PRED_SET		ORDDCM_CT_PRED	ORDDCM_CT_PRED_SET PID

Columns

Query Text

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

SELECT PID
,      FPID
,      POS
,      REF_PID
,      OP
,      DESCRIPTION
FROM ORDSYS.ORDDCM_CT_PRED;

Dependencies

[top of page]

ORDSYS.ORDDCM_CT_PRED does not reference any database object

ORDSYS.ORDDCM_CT_PRED is not referenced by any database object