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

TABLE: CSI.CSI_II_FORWARD_SYNC_TEMP

Object Details
Object Name: CSI_II_FORWARD_SYNC_TEMP
Object Type: TABLE
Owner: CSI
FND Design Data: TableCSI.CSI_II_FORWARD_SYNC_TEMP
Subobject Name:
Status: VALID


Temporary table used by the data correction process


Storage Details
Tablespace: TablespaceAPPS_TS_NOLOGGING
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSI_II_FORWARD_SYNC_TEMP_N01 NORMAL NONUNIQUE TablespaceAPPS_TS_NOLOGGING ColumnINSTANCE_ID
Columns
Name Datatype Length Mandatory Comments
INSTANCE_ID NUMBER

Item instance identifier
INVENTORY_ITEM_ID NUMBER

Inventory Item identifier
SERIAL_NUMBER VARCHAR2 (30)
Item instance serial number
LOT_CONTROL_CODE NUMBER

Lot control code for the item as setup in the inventory master organization
DATE_TIME_STAMP DATE

Time stamp used to forward sync the item instance.
MTL_TXN_ID NUMBER

Material transactions id of the inventory transaction for which item instance is corrected.
CSI_TXN_ID NUMBER

Item instance transaction id
CONTRACTS_FLAG VARCHAR2 (1)
Indicator if contracts need to be sync'ed.
PROCESS_FLAG VARCHAR2 (1)
Internal process flag
ERROR_MESSAGE VARCHAR2 (2000)
Error message if process fails
MTL_TXN_CREATION_DATE DATE

Material Transaction Creation Date
Query Text

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


SELECT INSTANCE_ID
,      INVENTORY_ITEM_ID
,      SERIAL_NUMBER
,      LOT_CONTROL_CODE
,      DATE_TIME_STAMP
,      MTL_TXN_ID
,      CSI_TXN_ID
,      CONTRACTS_FLAG
,      PROCESS_FLAG
,      ERROR_MESSAGE
,      MTL_TXN_CREATION_DATE
FROM CSI.CSI_II_FORWARD_SYNC_TEMP;

Dependencies

[top of page]

CSI.CSI_II_FORWARD_SYNC_TEMP does not reference any database object

CSI.CSI_II_FORWARD_SYNC_TEMP is referenced by following:

SchemaAPPS
SynonymCSI_II_FORWARD_SYNC_TEMP