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

TABLE: APPS.MLOG$_POA_DBI_PLL_MV

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

snapshot log for master table APPS.POA_DBI_PLL_MV

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 60
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BASE_UOM VARCHAR2 (25)
BASE_UOM_CONV_RATE NUMBER

BUYER_ID NUMBER

CATEGORY_ID NUMBER

COMMODITY_ID NUMBER

COMPLEX_WORK_FLAG VARCHAR2 (1)
DAYS_EARLY_RECEIPT_ALLOWED NUMBER

DAYS_LATE_RECEIPT_ALLOWED NUMBER

EXPECTED_DATE DATE

FUNC_CUR_CODE VARCHAR2 (25)
ITEM_ID NUMBER

LINE_LOCATION_ID NUMBER

MATCHING_BASIS VARCHAR2 (30)
ORDER_TYPE VARCHAR2 (25)
PAYMENT_TYPE VARCHAR2 (30)
PO_ITEM_ID NUMBER

PRICE_OVERRIDE NUMBER

RECEIVING_ROUTING_ID NUMBER

SHIPMENT_TYPE VARCHAR2 (25)
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 BASE_UOM
,      BASE_UOM_CONV_RATE
,      BUYER_ID
,      CATEGORY_ID
,      COMMODITY_ID
,      COMPLEX_WORK_FLAG
,      DAYS_EARLY_RECEIPT_ALLOWED
,      DAYS_LATE_RECEIPT_ALLOWED
,      EXPECTED_DATE
,      FUNC_CUR_CODE
,      ITEM_ID
,      LINE_LOCATION_ID
,      MATCHING_BASIS
,      ORDER_TYPE
,      PAYMENT_TYPE
,      PO_ITEM_ID
,      PRICE_OVERRIDE
,      RECEIVING_ROUTING_ID
,      SHIPMENT_TYPE
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_POA_DBI_PLL_MV;

Dependencies

[top of page]

APPS.MLOG$_POA_DBI_PLL_MV does not reference any database object

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