[Home] [Help] [Dependency Information]
Object Name: | ORDDCM_CT_PRED_WRK |
---|---|
Object Type: | TABLE |
Owner: | ORDDATA |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ORDDCM_CT_PRED_W_PK | NORMAL | UNIQUE | SYSTEM | PID |
ORDDCM_CT_PW_FPID_IDX | NORMAL | NONUNIQUE | SYSTEM | FPID |
ORDDCM_CT_PW_OP_IDX | NORMAL | NONUNIQUE | SYSTEM | OP |
ORDDCM_CT_PW_REF_IDX | NORMAL | NONUNIQUE | SYSTEM | REF_PID |
Table | |
Foreign Table | Foreign Key Column | ORDDCM_CT_PRED_WRK | ORDDCM_CT_PRED_WRK | ORDDCM_CT_PRED_WRK REF_PID | ORDDCM_CT_PRED_WRK | ORDDCM_CT_PRED_WRK | ORDDCM_CT_PRED_WRK FPID | ORDDCM_CT_ACTION_WRK | ORDDCM_CT_PRED_WRK | ORDDCM_CT_ACTION_WRK PID | ORDDCM_CT_PRED_OPRD_WRK | ORDDCM_CT_PRED_WRK | ORDDCM_CT_PRED_OPRD_WRK PID | ORDDCM_CT_PRED_PAR_WRK | ORDDCM_CT_PRED_WRK | ORDDCM_CT_PRED_PAR_WRK PID | ORDDCM_CT_PRED_SET_WRK | ORDDCM_CT_PRED_WRK | ORDDCM_CT_PRED_SET_WRK PID | ORDDCM_CT_PRED_WRK | ORDDCM_CT_PRED_WRK | ORDDCM_CT_PRED_WRK REF_PID | ORDDCM_CT_PRED_WRK | ORDDCM_CT_PRED_WRK | ORDDCM_CT_PRED_WRK FPID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PID | NUMBER | Yes | ||
FPID | NUMBER | |||
POS | NUMBER | (3) | Yes | |
REF_PID | NUMBER | |||
OP | NUMBER | (3) | ||
DESCRIPTION | VARCHAR2 | (1999) |
Cut, paste (and edit) the following text to query this object:
SELECT PID
, FPID
, POS
, REF_PID
, OP
, DESCRIPTION
FROM ORDDATA.ORDDCM_CT_PRED_WRK;
ORDDATA.ORDDCM_CT_PRED_WRK does not reference any database object
ORDDATA.ORDDCM_CT_PRED_WRK is referenced by following:
|
|
|