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

TABLE: BIV.MLOG$_BIV_DBI_BACKLOG_SUM_

Object Details
Object Name: MLOG$_BIV_DBI_BACKLOG_SUM_
Object Type: TABLE
Owner: BIV
Subobject Name:
Status: VALID

snapshot log for master table BIV.BIV_DBI_BACKLOG_SUM_F

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BACKLOG_DATE_FROM DATE

BACKLOG_DATE_TO DATE

CUSTOMER_ID NUMBER

ESCALATED_DATE DATE

INCIDENT_DATE DATE

INCIDENT_SEVERITY_ID NUMBER

INCIDENT_STATUS_ID NUMBER

INCIDENT_TYPE_ID NUMBER

INVENTORY_ITEM_ID NUMBER

INV_ORGANIZATION_ID NUMBER

OWNER_GROUP_ID NUMBER

SR_CREATION_CHANNEL VARCHAR2 (50)
UNOWNED_DATE DATE

M_ROW$$ VARCHAR2 (255)
SEQUENCE$$ NUMBER

SNAPTIME$$ DATE

DMLTYPE$$ VARCHAR2 (1)
OLD_NEW$$ VARCHAR2 (1)
CHANGE_VECTOR$$ RAW (255)
ESCALATED_FLAG VARCHAR2 (1)
INCIDENT_OWNER_ID NUMBER

INCIDENT_RESOLVED_DATE DATE

INCIDENT_URGENCY_ID NUMBER

RESOLVED_FLAG VARCHAR2 (1)
Query Text

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


SELECT BACKLOG_DATE_FROM
,      BACKLOG_DATE_TO
,      CUSTOMER_ID
,      ESCALATED_DATE
,      INCIDENT_DATE
,      INCIDENT_SEVERITY_ID
,      INCIDENT_STATUS_ID
,      INCIDENT_TYPE_ID
,      INVENTORY_ITEM_ID
,      INV_ORGANIZATION_ID
,      OWNER_GROUP_ID
,      SR_CREATION_CHANNEL
,      UNOWNED_DATE
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
,      ESCALATED_FLAG
,      INCIDENT_OWNER_ID
,      INCIDENT_RESOLVED_DATE
,      INCIDENT_URGENCY_ID
,      RESOLVED_FLAG
FROM BIV.MLOG$_BIV_DBI_BACKLOG_SUM_;

Dependencies

[top of page]

BIV.MLOG$_BIV_DBI_BACKLOG_SUM_ does not reference any database object

BIV.MLOG$_BIV_DBI_BACKLOG_SUM_ is referenced by following:

SchemaAPPS
SynonymMLOG$_BIV_DBI_BACKLOG_SUM_