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

TABLE: OPI.OPI_DBI_INV_VALUE_LOG

Object Details
Object Name: OPI_DBI_INV_VALUE_LOG
Object Type: TABLE
Owner: OPI
Subobject Name:
Status: VALID


Log table for Inventory related ETL's run time bounds. Stores start and end bounds and last collection dates.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Organization ID as in the LTP system.
TRANSACTION_ID NUMBER
Yes Transaction ID in the OLTP tables at which data collection stops.
TRANSACTION_DATE DATE

Date of transaction with transaction_id.
TYPE VARCHAR2 (3) Yes (MMT, WTA, ERR, CLR, CCA)
UNCOSTED_TRX_ID NUMBER

Transaction Id of the first uncosted transaction in MMT.
SOURCE NUMBER
Yes Source: 1 if OPI or 2 if OPM.
CREATION_DATE DATE
Yes Creation Date.
LAST_UPDATE_DATE DATE
Yes Last Update Date.
CREATED_BY NUMBER
Yes Standard WHO column.
LAST_UPDATED_BY NUMBER
Yes Standard WHO column.
LAST_UPDATE_LOGIN NUMBER

Standard WHO column.
FROM_TRANSACTION_ID NUMBER

Transaction ID in OLTP tables at which data collection starts.
FROM_TRANSACTION_DATE DATE

Date of transaction with from_transaction_id.
Query Text

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


SELECT ORGANIZATION_ID
,      TRANSACTION_ID
,      TRANSACTION_DATE
,      TYPE
,      UNCOSTED_TRX_ID
,      SOURCE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FROM_TRANSACTION_ID
,      FROM_TRANSACTION_DATE
FROM OPI.OPI_DBI_INV_VALUE_LOG;

Dependencies

[top of page]

OPI.OPI_DBI_INV_VALUE_LOG does not reference any database object

OPI.OPI_DBI_INV_VALUE_LOG is referenced by following:

SchemaAPPS
SynonymOPI_DBI_INV_VALUE_LOG