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


TABLE: APPS.MLOG$_ISC_DBI_CFM_000_MV

Object Details
Object Name: MLOG$_ISC_DBI_CFM_000_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID

snapshot log for master table APPS.ISC_DBI_CFM_000_MV

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 60
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BOOKED_AMT2_F NUMBER

BOOKED_AMT2_G NUMBER

BOOKED_AMT2_G1 NUMBER

BOOKED_AMT_F NUMBER

BOOKED_AMT_G NUMBER

BOOKED_AMT_G1 NUMBER

BOOKED_LINE_CNT NUMBER

BOOKED_QTY NUMBER

BOOKED_QTY2 NUMBER

CUSTOMER_FLAG NUMBER

CUSTOMER_ID NUMBER

INV_ORG_ID NUMBER

ITEM_CATEGORY_ID NUMBER

ITEM_CAT_FLAG NUMBER

ITEM_ID VARCHAR2 (25)
PERIOD_TYPE_ID NUMBER

REQUESTED_DAYS NUMBER

SCHEDULED_DAYS NUMBER

TIME_ID NUMBER

UOM VARCHAR2 (30)
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 BOOKED_AMT2_F
,      BOOKED_AMT2_G
,      BOOKED_AMT2_G1
,      BOOKED_AMT_F
,      BOOKED_AMT_G
,      BOOKED_AMT_G1
,      BOOKED_LINE_CNT
,      BOOKED_QTY
,      BOOKED_QTY2
,      CUSTOMER_FLAG
,      CUSTOMER_ID
,      INV_ORG_ID
,      ITEM_CATEGORY_ID
,      ITEM_CAT_FLAG
,      ITEM_ID
,      PERIOD_TYPE_ID
,      REQUESTED_DAYS
,      SCHEDULED_DAYS
,      TIME_ID
,      UOM
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_ISC_DBI_CFM_000_MV;

Dependencies

[top of page]

APPS.MLOG$_ISC_DBI_CFM_000_MV does not reference any database object

APPS.MLOG$_ISC_DBI_CFM_000_MV is not referenced by any database object