[Home] [Help] [Dependency Information]
Object Name: | OPI_DBI_INV_VALUE_LOG_TMP |
---|---|
Object Type: | TABLE |
Owner: | OPI |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Organization ID as in the LTP system. | ||
TRANSACTION_ID | NUMBER | Transaction ID in the OLTP tables at which data collection stops. | ||
TRANSACTION_DATE | DATE | Date of transaction with transaction_id. | ||
TYPE | VARCHAR2 | (3) | (MMT, WTA, ERR, CLR, CCA) | |
SOURCE | NUMBER | Source: 1 if OPI or 2 if OPM. |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, TRANSACTION_ID
, TRANSACTION_DATE
, TYPE
, SOURCE
FROM OPI.OPI_DBI_INV_VALUE_LOG_TMP;
OPI.OPI_DBI_INV_VALUE_LOG_TMP does not reference any database object
OPI.OPI_DBI_INV_VALUE_LOG_TMP is referenced by following:
|
|
|