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

TABLE: ISC.MLOG$_ISC_DBI_SHORTFALL_SN

Object Details
Object Name: MLOG$_ISC_DBI_SHORTFALL_SN
Object Type: TABLE
Owner: ISC
Subobject Name:
Status: VALID

snapshot log for master table ISC.ISC_DBI_SHORTFALL_SNAPSHOTS

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
COST_SHORTFALL NUMBER

COST_SHORTFALL_G NUMBER

DMD_ITEM_ID NUMBER

ORGANIZATION_ID NUMBER

ORGANIZATION_TYPE NUMBER

PERIOD_TYPE_ID NUMBER

REASON_TYPE NUMBER

REV_SHORTFALL NUMBER

REV_SHORTFALL_G NUMBER

R_DEPARTMENT_ID NUMBER

R_ITEM_ID NUMBER

R_ORG_ID NUMBER

R_RESOURCE_ID NUMBER

R_SUPPLIER_ID NUMBER

R_SUPPLIER_SITE_ID NUMBER

SNAPSHOT_ID NUMBER

START_DATE DATE

M_ROW$$ VARCHAR2 (255)
SEQUENCE$$ NUMBER

SNAPTIME$$ DATE

DMLTYPE$$ VARCHAR2 (1)
OLD_NEW$$ VARCHAR2 (1)
CHANGE_VECTOR$$ RAW (255)
COST_SHORTFALL_G1 NUMBER

REV_SHORTFALL_G1 NUMBER

Query Text

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


SELECT COST_SHORTFALL
,      COST_SHORTFALL_G
,      DMD_ITEM_ID
,      ORGANIZATION_ID
,      ORGANIZATION_TYPE
,      PERIOD_TYPE_ID
,      REASON_TYPE
,      REV_SHORTFALL
,      REV_SHORTFALL_G
,      R_DEPARTMENT_ID
,      R_ITEM_ID
,      R_ORG_ID
,      R_RESOURCE_ID
,      R_SUPPLIER_ID
,      R_SUPPLIER_SITE_ID
,      SNAPSHOT_ID
,      START_DATE
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
,      COST_SHORTFALL_G1
,      REV_SHORTFALL_G1
FROM ISC.MLOG$_ISC_DBI_SHORTFALL_SN;

Dependencies

[top of page]

ISC.MLOG$_ISC_DBI_SHORTFALL_SN does not reference any database object

ISC.MLOG$_ISC_DBI_SHORTFALL_SN is referenced by following:

SchemaAPPS
SynonymMLOG$_ISC_DBI_SHORTFALL_SN