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

TABLE: APPS.MLOG$_BIL_BI_OP11_PG_MV

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

snapshot log for master table APPS.BIL_BI_OP11_PG_MV

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

CNV_OPTY_AMT_S NUMBER

EFFECTIVE_TIME_ID NUMBER

ITEM_ID NUMBER

LATEST_OPEN_OPTY_AMT NUMBER

LATEST_OPEN_OPTY_AMT_S NUMBER

LOST_OPTY_AMT NUMBER

LOST_OPTY_AMT_S NUMBER

NEW_OPTY_AMT NUMBER

NEW_OPTY_AMT_S NUMBER

NFP_PER NUMBER

NFP_PER_S NUMBER

NFP_QTR NUMBER

NFP_QTR_S NUMBER

NFP_WK NUMBER

NFP_WK_S NUMBER

NFP_YR NUMBER

NFP_YR_S NUMBER

NO_OPTY_AMT NUMBER

NO_OPTY_AMT_S NUMBER

PRODUCT_CATEGORY_ID NUMBER

SALESREP_ID NUMBER

SALES_GROUP_ID NUMBER

WON_OPTY_AMT NUMBER

WON_OPTY_AMT_S 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 CNV_OPTY_AMT
,      CNV_OPTY_AMT_S
,      EFFECTIVE_TIME_ID
,      ITEM_ID
,      LATEST_OPEN_OPTY_AMT
,      LATEST_OPEN_OPTY_AMT_S
,      LOST_OPTY_AMT
,      LOST_OPTY_AMT_S
,      NEW_OPTY_AMT
,      NEW_OPTY_AMT_S
,      NFP_PER
,      NFP_PER_S
,      NFP_QTR
,      NFP_QTR_S
,      NFP_WK
,      NFP_WK_S
,      NFP_YR
,      NFP_YR_S
,      NO_OPTY_AMT
,      NO_OPTY_AMT_S
,      PRODUCT_CATEGORY_ID
,      SALESREP_ID
,      SALES_GROUP_ID
,      WON_OPTY_AMT
,      WON_OPTY_AMT_S
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_BIL_BI_OP11_PG_MV;

Dependencies

[top of page]

APPS.MLOG$_BIL_BI_OP11_PG_MV does not reference any database object

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