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


TABLE: ORDSYS.ORDDCM_VR_DT_MAP

Object Details
Object Name: ORDDCM_VR_DT_MAP
Object Type: TABLE
Owner: ORDSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: ORDDCM_VR_DT_MAP_PK1
  1. ColumnVR
Indexes
Index Type Uniqueness Tablespace Column
ORDDCM_VR_DT_MAP_PK1 NORMAL UNIQUE TablespaceSYSTEM ColumnVR
Foreign Keys
Table
Foreign Table Foreign Key Column
TableORDDCM_PRV_ATTRS ORDDCM_PRV_ATTRS_FK2 ORDDCM_VR_DT_MAP ORDDCM_PRV_ATTRS VR
TableORDDCM_PRV_ATTRS_WRK ORDDCM_PRV_ATTRS_W_FK2 ORDDCM_VR_DT_MAP ORDDCM_PRV_ATTRS_WRK VR
TableORDDCM_STD_ATTRS ORDDCM_SD_ATTRS_FK1 ORDDCM_VR_DT_MAP ORDDCM_STD_ATTRS VR
TableORDDCM_STD_ATTRS_WRK ORDDCM_SD_ATTRS_W_FK1 ORDDCM_VR_DT_MAP ORDDCM_STD_ATTRS_WRK VR
Columns
Name Datatype Length Mandatory Comments
VR_NUM NUMBER (38) Yes
VR VARCHAR2 (5) Yes
DT VARCHAR2 (32) Yes
Query Text

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


SELECT VR_NUM
,      VR
,      DT
FROM ORDSYS.ORDDCM_VR_DT_MAP;

Dependencies

[top of page]

ORDSYS.ORDDCM_VR_DT_MAP does not reference any database object

ORDSYS.ORDDCM_VR_DT_MAP is not referenced by any database object