[Home] [Help] [Dependency Information]
Object Name: | CSI_II_FORWARD_SYNC_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | CSI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INSTANCE_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
SERIAL_NUMBER | VARCHAR2 | (30) | ||
LOT_CONTROL_CODE | NUMBER | |||
DATE_TIME_STAMP | DATE | |||
MTL_TXN_ID | NUMBER | |||
CSI_TXN_ID | NUMBER | |||
CONTRACTS_FLAG | VARCHAR2 | (1) | ||
PROCESS_FLAG | VARCHAR2 | (1) | ||
ERROR_MESSAGE | VARCHAR2 | (2000) | ||
MTL_TXN_CREATION_DATE | DATE |
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#;
|
|
|