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_INV_DISCREPANCY_TEMP

Object Details

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

Temporary table which holds the descrepancy between item instance records and inventory onhand balances. Used only for reporting purpuses and the records are deleted the report is produced.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
DISCREPANCY_ID	NUMBER		Yes	Internal Id
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item id
SERIAL_NUMBER	VARCHAR2	(30)		Serial number of the item
INV_REVISION	VARCHAR2	(3)		Revision of the item as in inventory
INV_LOT_NUMBER	VARCHAR2	(80)		Lot number of the item as in inventory
INV_QUANTITY	NUMBER			Quantity of the item as in inventory
INV_ORGANIZATION_ID	NUMBER			Inventory organization of the item as in inventory
INV_SUBINVENTORY_NAME	VARCHAR2	(10)		Sub Inventory of the item as in inventory
INV_LOCATOR_ID	NUMBER			Inventory locator of the item as in inventory
INSTANCE_ID	NUMBER			Corresponding item instance id
II_REVISION	VARCHAR2	(3)		Revision of the item instance.
II_LOT_NUMBER	VARCHAR2	(80)		Lot number of the item instance.
II_QUANTITY	NUMBER			Quantity of the item instance.
II_LOCATION_TYPE_CODE	VARCHAR2	(30)		Location type code of the item instance.
II_ORGANIZATION_ID	NUMBER			Inventory organization of the item instance.
II_SUBINVENTORY_NAME	VARCHAR2	(10)		Subinventory of the item instance.
II_LOCATOR_ID	NUMBER			Locator of the item instance
INSTANCE_USAGE_CODE	VARCHAR2	(30)		Usage code of the item instance
MASTER_ORG_TRACKABLE_FLAG	VARCHAR2	(1)		Trackable flag value of the item in the master organization
CHILD_ORG_TRACKABLE_FLAG	VARCHAR2	(1)		Trackable flag value of the item in the child organization
ERROR_TEXT	VARCHAR2	(500)		Descipency related error message

Query Text

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


SELECT DISCREPANCY_ID
,      INVENTORY_ITEM_ID
,      SERIAL_NUMBER
,      INV_REVISION
,      INV_LOT_NUMBER
,      INV_QUANTITY
,      INV_ORGANIZATION_ID
,      INV_SUBINVENTORY_NAME
,      INV_LOCATOR_ID
,      INSTANCE_ID
,      II_REVISION
,      II_LOT_NUMBER
,      II_QUANTITY
,      II_LOCATION_TYPE_CODE
,      II_ORGANIZATION_ID
,      II_SUBINVENTORY_NAME
,      II_LOCATOR_ID
,      INSTANCE_USAGE_CODE
,      MASTER_ORG_TRACKABLE_FLAG
,      CHILD_ORG_TRACKABLE_FLAG
,      ERROR_TEXT
FROM CSI.CSI_INV_DISCREPANCY_TEMP;

Dependencies

[top of page]

CSI.CSI_INV_DISCREPANCY_TEMP does not reference any database object

CSI.CSI_INV_DISCREPANCY_TEMP is referenced by following:

CSI: CSI_INV_DISCREPANCY_TEMP#