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: QA.QA_CSI_ITEM_INSTANCES_DUMMY

Object Details

Object Name:	QA_CSI_ITEM_INSTANCES_DUMMY
Object Type:	TABLE
Owner:	QA
FND Design Data:	QA.QA_CSI_ITEM_INSTANCES_DUMMY
Subobject Name:
Status:	VALID

Dummy table that mirrors a subset of csi_item_instances. This table is used to resolving splicing issue when QA needs to reference csi_item_instances table. There will be a synonym qa_csi_item_instances that points to this dummy table initially. Then, CSI installation will repoint the synonym to point to csi_item_instances.. Oracle Internal use only - reserved for future use

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
INSTANCE_ID	NUMBER		Yes	instance ID
INSTANCE_NUMBER	VARCHAR2	(30)	Yes	instance number
INVENTORY_ITEM_ID	NUMBER			Item ID
LAST_VLD_ORGANIZATION_ID	NUMBER			Last valid organization ID
INV_MASTER_ORGANIZATION_ID	NUMBER			Master Org ID
SERIAL_NUMBER	VARCHAR2	(30)		Serial Number, either inventory or installed base serial
MFG_SERIAL_NUMBER_FLAG	VARCHAR2	(1)		manufacturing serial number flag
LOT_NUMBER	VARCHAR2	(80)		Lot number, either inventory or installed base
QUANTITY	NUMBER			quantity
UNIT_OF_MEASURE	VARCHAR2	(3)		UOM
ACTIVE_START_DATE	DATE			active date range
ACTIVE_END_DATE	DATE			active date range
CREATION_DATE	DATE			Standard WHO column
CREATED_BY	NUMBER			Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATED_BY	NUMBER			Standard WHO column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column

Query Text

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


SELECT INSTANCE_ID
,      INSTANCE_NUMBER
,      INVENTORY_ITEM_ID
,      LAST_VLD_ORGANIZATION_ID
,      INV_MASTER_ORGANIZATION_ID
,      SERIAL_NUMBER
,      MFG_SERIAL_NUMBER_FLAG
,      LOT_NUMBER
,      QUANTITY
,      UNIT_OF_MEASURE
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM QA.QA_CSI_ITEM_INSTANCES_DUMMY;

Dependencies

[top of page]

QA.QA_CSI_ITEM_INSTANCES_DUMMY does not reference any database object

QA.QA_CSI_ITEM_INSTANCES_DUMMY is referenced by following:

APPS: QA_CSI_ITEM_INSTANCES_DUMMY