eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: CSI.CSI_DIAGNOSTICS_TEMP

Object Details

Object Name:	CSI_DIAGNOSTICS_TEMP
Object Type:	TABLE
Owner:	CSI
FND Design Data:	CSI.CSI_DIAGNOSTICS_TEMP
Subobject Name:
Status:	VALID

Temporary table used by the data correction process.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSI_DIAGNOSTICS_TEMP_U01	NORMAL	UNIQUE	APPS_TS_NOLOGGING	DIAG_SEQ_ID
CSI_DIAGNOSTICS_TEMP_U02	NORMAL	UNIQUE	APPS_TS_NOLOGGING	SERIAL_NUMBER INVENTORY_ITEM_ID MTL_TXN_ID
CSI_DIAGNOSTICS_TEMP_N01	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	MTL_TXN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DIAG_SEQ_ID	NUMBER		Yes	Internal id
SERIAL_NUMBER	VARCHAR2	(30)		Serial number of the item in problem
MTL_TXN_DATE	DATE			Material transaction date in inventory, if inventory transaction
MTL_TXN_ID	NUMBER			Material transaction id in inventory, if inventory transaction
MTL_TXN_NAME	VARCHAR2	(240)		Material transaction name in inventory, if inventory transaction
MTL_TXN_QTY	NUMBER			Material transaction quantity in inventory, if inventory transaction
MTL_TYPE_ID	NUMBER			Material transaction type id in inventory, if inventory transaction
MTL_ACTION_ID	NUMBER			Material transaction action id in inventory, if inventory transaction
MTL_SRC_TYPE_ID	NUMBER			Material transaction source id in inventory, if inventory transaction
MTL_TYPE_CLASS	NUMBER			Material transaction type class in inventory, if inventory transaction
SOURCE_TYPE	VARCHAR2	(30)		Item instance transaction type in install base.
CSI_TXN_TYPE_ID	NUMBER			Item Instance source transaction type id
CSI_TXN_ID	NUMBER			Item Instance transaction id
ERROR_FLAG	VARCHAR2	(1)		E-Error, P-Processed
ERROR_TEXT	VARCHAR2	(2000)		Description of the error
INVENTORY_ITEM_ID	NUMBER			Inventory item id of the transaction in error
SERIAL_CONTROL_CODE	NUMBER			Serial control code for the item as setup in the inventory organization
LOT_CONTROL_CODE	NUMBER			Lot control code for the item as setup in the inventory master organization
LOT_NUMBER	VARCHAR2	(80)		Lot number of the item instance
ORGANIZATION_ID	NUMBER			Inventory organization id
OE_ORDER_LINE_ID	NUMBER			Order Line id reference
WIP_JOB_ID	NUMBER			Work in process job id reference
OE_RMA_LINE_ID	NUMBER			RMA Order Line id reference
INSTANCE_ID	NUMBER			Identified item instance id
INSTANCE_VLD_ORGANIZATION_ID	NUMBER			Current validation organization id for the item instance
INSTANCE_LOCATION	VARCHAR2	(30)		Current instance location id for the item instance
INSTANCE_USAGE_CODE	VARCHAR2	(30)		Current instance usage code for the item instance
INSTANCE_ORGANIZATION_ID	NUMBER			Current located inventory organization for the item instance
INSTANCE_SUBINV_NAME	VARCHAR2	(80)		Current located sub inventory for the item instance
INSTANCE_REVISION	VARCHAR2	(3)		Current revision level for the item instance
INSTANCE_END_DATE	DATE			Active end date of the item instance, NULL if active.
INSTANCE_OWNER_PARTY_ID	NUMBER			Current owner party of the item instance
INSTANCE_OWNER_ACCOUNT_ID	NUMBER			Current owner party account of the item instance
INSTANCE_MIG_FLAG	VARCHAR2	(1)		Indicates if the item instance is upgraded from a previous release prior ro 11.5.6 release.
INTERNAL_PARTY_ID	NUMBER			Internal party setup in install parameter
LAST_TRANSACTION_FLAG	VARCHAR2	(1)		Indicator if this is the last transaction
ENTANGLED_FLAG	VARCHAR2	(1)		Indicates if this item instance is entangled in a group of other item instances in different transactions.
CREATE_FLAG	VARCHAR2	(1)		Indicated if a new item instance needs to be created to handle the error.
EXPIRE_FLAG	VARCHAR2	(1)		Indicated if this item instance needs to be expired to correct the error.
PROCESS_CODE	VARCHAR2	(30)		Internal process code for the error correction process.
PROCESS_FLAG	VARCHAR2	(1)		Internal process flag for the error correction process.
TEMPORARY_MESSAGE	VARCHAR2	(2000)		Internal temporary message for the error correction process.
MTL_CREATION_DATE	DATE			Material Creation Date
REVISION_CONTROL_CODE	NUMBER			Revision Control Code
MTL_XFER_TXN_ID	NUMBER			Material Transfer Transaction Identifier
MTL_ITEM_REVISION	VARCHAR2	(3)		Material Item Revision

Query Text

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


SELECT DIAG_SEQ_ID
,      SERIAL_NUMBER
,      MTL_TXN_DATE
,      MTL_TXN_ID
,      MTL_TXN_NAME
,      MTL_TXN_QTY
,      MTL_TYPE_ID
,      MTL_ACTION_ID
,      MTL_SRC_TYPE_ID
,      MTL_TYPE_CLASS
,      SOURCE_TYPE
,      CSI_TXN_TYPE_ID
,      CSI_TXN_ID
,      ERROR_FLAG
,      ERROR_TEXT
,      INVENTORY_ITEM_ID
,      SERIAL_CONTROL_CODE
,      LOT_CONTROL_CODE
,      LOT_NUMBER
,      ORGANIZATION_ID
,      OE_ORDER_LINE_ID
,      WIP_JOB_ID
,      OE_RMA_LINE_ID
,      INSTANCE_ID
,      INSTANCE_VLD_ORGANIZATION_ID
,      INSTANCE_LOCATION
,      INSTANCE_USAGE_CODE
,      INSTANCE_ORGANIZATION_ID
,      INSTANCE_SUBINV_NAME
,      INSTANCE_REVISION
,      INSTANCE_END_DATE
,      INSTANCE_OWNER_PARTY_ID
,      INSTANCE_OWNER_ACCOUNT_ID
,      INSTANCE_MIG_FLAG
,      INTERNAL_PARTY_ID
,      LAST_TRANSACTION_FLAG
,      ENTANGLED_FLAG
,      CREATE_FLAG
,      EXPIRE_FLAG
,      PROCESS_CODE
,      PROCESS_FLAG
,      TEMPORARY_MESSAGE
,      MTL_CREATION_DATE
,      REVISION_CONTROL_CODE
,      MTL_XFER_TXN_ID
,      MTL_ITEM_REVISION
FROM CSI.CSI_DIAGNOSTICS_TEMP;

Dependencies

[top of page]

CSI.CSI_DIAGNOSTICS_TEMP does not reference any database object

CSI.CSI_DIAGNOSTICS_TEMP is referenced by following:

APPS: CSI_DIAGNOSTICS_TEMP