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

TABLE: POA.MLOG$_POA_DBI_POD_F

Object Details
Object Name: MLOG$_POA_DBI_POD_F
Object Type: TABLE
Owner: POA
Subobject Name:
Status: VALID

snapshot log for master table POA.POA_DBI_POD_F

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

AMT_RECOUPED NUMBER

APPROVED_DATE DATE

AUCTION_HEADER_ID NUMBER

AUCTION_LINE_NUMBER NUMBER

BASE_UOM VARCHAR2 (25)
BASE_UOM_CONV_RATE NUMBER

BID_LINE_NUMBER NUMBER

BID_NUMBER NUMBER

BUYER_ID NUMBER

CATEGORY_ID NUMBER

COMPANY_ID NUMBER

COMPLEX_WORK_FLAG VARCHAR2 (1)
CONSIGNED_CODE NUMBER

CONTRACT_AMOUNT_B NUMBER

COST_CENTER_ID NUMBER

CREATION_OPERATING_UNIT_ID NUMBER

DAYS_EARLY_RECEIPT_ALLOWED NUMBER

DAYS_LATE_RECEIPT_ALLOWED NUMBER

DOCTYPE_ID NUMBER

EXPECTED_DATE DATE

FROM_DOCUMENT_TYPE VARCHAR2 (25)
FUNC_CUR_CONV_RATE NUMBER

GLOBAL_CUR_CONV_RATE NUMBER

ITEM_ID NUMBER

LINE_LOCATION_ID NUMBER

MATCHING_BASIS VARCHAR2 (30)
NEGOTIATED_BY_PREPARER_FLAG VARCHAR2 (1)
NEGOTIATION_CREATOR_ID NUMBER

NEG_BASE_UOM VARCHAR2 (25)
NEG_BASE_UOM_CONV_RATE NUMBER

NEG_CURRENT_PRICE NUMBER

NEG_FUNC_CUR_CODE VARCHAR2 (25)
NEG_FUNC_CUR_CONV_RATE NUMBER

NEG_GLOBAL_CUR_CONV_RATE NUMBER

NEG_SGLOBAL_CUR_CONV_RATE NUMBER

NEG_TRANSACTION_UOM VARCHAR2 (25)
NON_CONTRACT_AMOUNT_B NUMBER

NON_ZERO_QUANTITY NUMBER

ORDER_TYPE VARCHAR2 (25)
PAYMENT_TYPE VARCHAR2 (30)
POT_CONTRACT_AMOUNT_B NUMBER

POT_SAVINGS_AMOUNT_B NUMBER

PO_HEADER_ID NUMBER

PO_ITEM_ID NUMBER

PO_LINE_ID NUMBER

PO_RELEASE_ID NUMBER

PRICE_OVERRIDE NUMBER

PURCHASE_AMOUNT_B NUMBER

QTY_FINANCED NUMBER

QTY_RECOUPED NUMBER

QUANTITY NUMBER

RECEIVING_ROUTING_ID NUMBER

SGLOBAL_CUR_CONV_RATE NUMBER

SHIPMENT_TYPE VARCHAR2 (25)
SHIP_TO_ORG_ID NUMBER

SUPPLIER_ID NUMBER

SUPPLIER_SITE_ID NUMBER

M_ROW$$ VARCHAR2 (255)
SEQUENCE$$ NUMBER

SNAPTIME$$ DATE

DMLTYPE$$ VARCHAR2 (1)
OLD_NEW$$ VARCHAR2 (1)
CHANGE_VECTOR$$ RAW (255)
FUNC_CUR_CODE VARCHAR2 (25)
Query Text

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


SELECT AMT_FINANCED
,      AMT_RECOUPED
,      APPROVED_DATE
,      AUCTION_HEADER_ID
,      AUCTION_LINE_NUMBER
,      BASE_UOM
,      BASE_UOM_CONV_RATE
,      BID_LINE_NUMBER
,      BID_NUMBER
,      BUYER_ID
,      CATEGORY_ID
,      COMPANY_ID
,      COMPLEX_WORK_FLAG
,      CONSIGNED_CODE
,      CONTRACT_AMOUNT_B
,      COST_CENTER_ID
,      CREATION_OPERATING_UNIT_ID
,      DAYS_EARLY_RECEIPT_ALLOWED
,      DAYS_LATE_RECEIPT_ALLOWED
,      DOCTYPE_ID
,      EXPECTED_DATE
,      FROM_DOCUMENT_TYPE
,      FUNC_CUR_CONV_RATE
,      GLOBAL_CUR_CONV_RATE
,      ITEM_ID
,      LINE_LOCATION_ID
,      MATCHING_BASIS
,      NEGOTIATED_BY_PREPARER_FLAG
,      NEGOTIATION_CREATOR_ID
,      NEG_BASE_UOM
,      NEG_BASE_UOM_CONV_RATE
,      NEG_CURRENT_PRICE
,      NEG_FUNC_CUR_CODE
,      NEG_FUNC_CUR_CONV_RATE
,      NEG_GLOBAL_CUR_CONV_RATE
,      NEG_SGLOBAL_CUR_CONV_RATE
,      NEG_TRANSACTION_UOM
,      NON_CONTRACT_AMOUNT_B
,      NON_ZERO_QUANTITY
,      ORDER_TYPE
,      PAYMENT_TYPE
,      POT_CONTRACT_AMOUNT_B
,      POT_SAVINGS_AMOUNT_B
,      PO_HEADER_ID
,      PO_ITEM_ID
,      PO_LINE_ID
,      PO_RELEASE_ID
,      PRICE_OVERRIDE
,      PURCHASE_AMOUNT_B
,      QTY_FINANCED
,      QTY_RECOUPED
,      QUANTITY
,      RECEIVING_ROUTING_ID
,      SGLOBAL_CUR_CONV_RATE
,      SHIPMENT_TYPE
,      SHIP_TO_ORG_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
,      FUNC_CUR_CODE
FROM POA.MLOG$_POA_DBI_POD_F;

Dependencies

[top of page]

POA.MLOG$_POA_DBI_POD_F does not reference any database object

POA.MLOG$_POA_DBI_POD_F is referenced by following:

SchemaAPPS
SynonymMLOG$_POA_DBI_POD_F