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

TABLE: APPS.MLOG$_POA_PQC_001_MV

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

snapshot log for master table APPS.POA_PQC_001_MV

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

BASE_UOM VARCHAR2 (25)
CATEGORY_ID NUMBER

COMMODITY_ID NUMBER

COMPANY_ID NUMBER (15)
COST_CENTER_ID NUMBER (15)
GRP_ID NUMBER

ORG_ID NUMBER

PBCQCO_AMT_B NUMBER

PBCQCO_AMT_G NUMBER

PBCQCO_AMT_SG NUMBER

PBPCQCO_AMT_B NUMBER

PBPCQCO_AMT_G NUMBER

PBPCQCO_AMT_SG NUMBER

PBPCQCS_AMT_B NUMBER

PBPCQCS_AMT_G NUMBER

PBPCQCS_AMT_SG NUMBER

PO_ITEM_ID NUMBER

PURCHASE_AMT_B NUMBER

PURCHASE_AMT_G NUMBER

PURCHASE_AMT_SG NUMBER

QUANTITY NUMBER

SUPPLIER_ID NUMBER

TIME_ID 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 AGGREGATION_LEVEL
,      BASE_UOM
,      CATEGORY_ID
,      COMMODITY_ID
,      COMPANY_ID
,      COST_CENTER_ID
,      GRP_ID
,      ORG_ID
,      PBCQCO_AMT_B
,      PBCQCO_AMT_G
,      PBCQCO_AMT_SG
,      PBPCQCO_AMT_B
,      PBPCQCO_AMT_G
,      PBPCQCO_AMT_SG
,      PBPCQCS_AMT_B
,      PBPCQCS_AMT_G
,      PBPCQCS_AMT_SG
,      PO_ITEM_ID
,      PURCHASE_AMT_B
,      PURCHASE_AMT_G
,      PURCHASE_AMT_SG
,      QUANTITY
,      SUPPLIER_ID
,      TIME_ID
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_POA_PQC_001_MV;

Dependencies

[top of page]

APPS.MLOG$_POA_PQC_001_MV does not reference any database object

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