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


TABLE: BIX.BIX_DM_DNIS

Object Details
Object Name: BIX_DM_DNIS
Object Type: TABLE
Owner: BIX
Subobject Name:
Status: VALID


This table stores all the DNIS .


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DNIS_ID NUMBER
Yes Unique identifier for the DNIS .
DNIS VARCHAR2 (30)
DNIS Name .
LAST_UPDATE_DATE DATE

Standard Who Column .
LAST_UPDATED_BY NUMBER

Standard Who Column .
CREATION_DATE DATE

Standard Who 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 .
NUM_ATTRIBUTE1 NUMBER

Numeric flexfield segment .
NUM_ATTRIBUTE2 NUMBER

Numeric flexfield segment .
NUM_ATTRIBUTE3 NUMBER

Numeric flexfield segment .
NUM_ATTRIBUTE4 NUMBER

Numeric flexfield segment .
CREATED_BY NUMBER

Standard Who Column .
Query Text

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


SELECT DNIS_ID
,      DNIS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      NUM_ATTRIBUTE1
,      NUM_ATTRIBUTE2
,      NUM_ATTRIBUTE3
,      NUM_ATTRIBUTE4
,      CREATED_BY
FROM BIX.BIX_DM_DNIS;

Dependencies

[top of page]

BIX.BIX_DM_DNIS does not reference any database object

BIX.BIX_DM_DNIS is referenced by following:

SchemaAPPS
SynonymBIX_DM_DNIS