[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| 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.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| 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. |
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;
OPI.OPI_DBI_INV_VALUE_LOG does not reference any database object
OPI.OPI_DBI_INV_VALUE_LOG is referenced by following:
APPS
OPI_DBI_INV_VALUE_LOG
|
|
|
|