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

TABLE: BIV.MLOG$_BIV_DBI_RESOLUTION_S

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

snapshot log for master table BIV.BIV_DBI_RESOLUTION_SUM_F

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 60
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CONTRACT_NUMBER VARCHAR2 (120)
CUSTOMER_ID NUMBER

ESCALATED_FLAG VARCHAR2 (1)
INCIDENT_DATE DATE

INCIDENT_ID NUMBER

INCIDENT_OWNER_ID NUMBER

INCIDENT_SEVERITY_ID NUMBER

INCIDENT_TYPE_ID NUMBER

INCIDENT_URGENCY_ID NUMBER

INVENTORY_ITEM_ID NUMBER

INV_ORGANIZATION_ID NUMBER

OWNER_GROUP_ID NUMBER

REPORT_DATE DATE

RESOLUTION_CODE VARCHAR2 (50)
RESOLVE_BY_DATE DATE

RESPOND_BY_DATE DATE

RESPOND_ON_DATE DATE

SR_CREATION_CHANNEL VARCHAR2 (50)
TIME_TO_RESOLUTION NUMBER

M_ROW$$ VARCHAR2 (255)
SEQUENCE$$ NUMBER

SNAPTIME$$ DATE

DMLTYPE$$ VARCHAR2 (1)
OLD_NEW$$ VARCHAR2 (1)
CHANGE_VECTOR$$ RAW (255)
Query Text

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


SELECT CONTRACT_NUMBER
,      CUSTOMER_ID
,      ESCALATED_FLAG
,      INCIDENT_DATE
,      INCIDENT_ID
,      INCIDENT_OWNER_ID
,      INCIDENT_SEVERITY_ID
,      INCIDENT_TYPE_ID
,      INCIDENT_URGENCY_ID
,      INVENTORY_ITEM_ID
,      INV_ORGANIZATION_ID
,      OWNER_GROUP_ID
,      REPORT_DATE
,      RESOLUTION_CODE
,      RESOLVE_BY_DATE
,      RESPOND_BY_DATE
,      RESPOND_ON_DATE
,      SR_CREATION_CHANNEL
,      TIME_TO_RESOLUTION
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM BIV.MLOG$_BIV_DBI_RESOLUTION_S;

Dependencies

[top of page]

BIV.MLOG$_BIV_DBI_RESOLUTION_S does not reference any database object

BIV.MLOG$_BIV_DBI_RESOLUTION_S is referenced by following:

SchemaAPPS
SynonymMLOG$_BIV_DBI_RESOLUTION_S