[Home] [Help] [Dependency Information]
Object Name: | OPI_DBI_COGS_RUN_LOG |
---|---|
Object Type: | TABLE |
Owner: | OPI |
Subobject Name: | |
Status: | VALID |
Log table for Initial and Incremental Loads of COGS Fact Table. Stores the last transaction_id and transaction_date for each Org.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Organization Identifier | ||
SOURCE | NUMBER | Data Source: 1 for Descrete Manufacturing and 2 for Process Manufacturing | ||
LAST_COLLECTION_DATE | DATE | Last Collection Date | ||
INIT_TXN_ID | NUMBER | Initial Transaction ID | ||
START_TXN_ID | NUMBER | Start Transaction ID | ||
NEXT_START_TXN_ID | NUMBER | Next Start Transaction ID | ||
STOP_REASON_CODE | NUMBER | Stop Reason Code | ||
LAST_TRANSACTION_DATE | DATE | Last Transaction Date |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, SOURCE
, LAST_COLLECTION_DATE
, INIT_TXN_ID
, START_TXN_ID
, NEXT_START_TXN_ID
, STOP_REASON_CODE
, LAST_TRANSACTION_DATE
FROM OPI.OPI_DBI_COGS_RUN_LOG;
OPI.OPI_DBI_COGS_RUN_LOG does not reference any database object
OPI.OPI_DBI_COGS_RUN_LOG is referenced by following:
|
|
|