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

TABLE: ISC.ISC_FS_INV_USG_LOG

Object Details
Object Name: ISC_FS_INV_USG_LOG
Object Type: TABLE
Owner: ISC
Subobject Name:
Status: VALID


This table stores the inventory transaction boundaries extracted after the last collection for every organization extracted. This table is used during our incremental collections to obtain the start transaction boundary of the next incremental collection for each organization.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Organization ID as in the OLTP system
FROM_TRANSACTION_ID NUMBER

Lower transaction id boundary
TO_TRANSACTION_ID NUMBER

Upper transaction id boundary. This is the last transaction id collected for the organization in the most recent extraction
CREATED_BY NUMBER

Standard who column
CREATION_DATE DATE

Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER

Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
PROGRAM_ID NUMBER

Standard who column
PROGRAM_LOGIN_ID NUMBER

Standard who column
PROGRAM_APPLICATION_ID NUMBER

Standard who column
REQUEST_ID NUMBER

Standard who column
Query Text

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


SELECT ORGANIZATION_ID
,      FROM_TRANSACTION_ID
,      TO_TRANSACTION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM ISC.ISC_FS_INV_USG_LOG;

Dependencies

[top of page]

ISC.ISC_FS_INV_USG_LOG does not reference any database object

ISC.ISC_FS_INV_USG_LOG is referenced by following:

SchemaAPPS
SynonymISC_FS_INV_USG_LOG