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.

[Home] [Help]

Table: CSI_ITEM_INSTANCES

Product:	CSI - Install Base
Description:	Item Instance details.
Implementation/DBA Data:	CSI.CSI_ITEM_INSTANCES

Primary Key: CSI_ITEM_INSTANCES_PK

INSTANCE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSI_ITEM_INSTANCES	MTL_SYSTEM_ITEMS_B	CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID
CSI_ITEM_INSTANCES	MTL_ITEM_REVISIONS_B	CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID CSI_ITEM_INSTANCES.INVENTORY_REVISION
CSI_ITEM_INSTANCES	MTL_SERIAL_NUMBERS	CSI_ITEM_INSTANCES.SERIAL_NUMBER CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID
CSI_ITEM_INSTANCES	MTL_LOT_NUMBERS	CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID CSI_ITEM_INSTANCES.LOT_NUMBER
CSI_ITEM_INSTANCES	MTL_MATERIAL_STATUSES_B	CSI_ITEM_INSTANCES.INSTANCE_CONDITION_ID
CSI_ITEM_INSTANCES	CSI_INSTANCE_STATUSES	CSI_ITEM_INSTANCES.INSTANCE_STATUS_ID
CSI_ITEM_INSTANCES	CSI_SYSTEMS_B	CSI_ITEM_INSTANCES.SYSTEM_ID
CSI_ITEM_INSTANCES	HZ_PARTY_SITES	CSI_ITEM_INSTANCES.LOCATION_ID
CSI_ITEM_INSTANCES	PA_PROJECTS_ALL	CSI_ITEM_INSTANCES.PA_PROJECT_ID
CSI_ITEM_INSTANCES	PA_TASKS	CSI_ITEM_INSTANCES.PA_PROJECT_TASK_ID
CSI_ITEM_INSTANCES	OE_ORDER_LINES_ALL	CSI_ITEM_INSTANCES.IN_TRANSIT_ORDER_LINE_ID
CSI_ITEM_INSTANCES	WIP_DISCRETE_JOBS	CSI_ITEM_INSTANCES.WIP_JOB_ID
CSI_ITEM_INSTANCES	PO_LINES_ALL	CSI_ITEM_INSTANCES.PO_ORDER_LINE_ID
AHL_PART_CHANGES	CSI_ITEM_INSTANCES	AHL_PART_CHANGES.REMOVED_INSTANCE_ID
AHL_PART_CHANGES	CSI_ITEM_INSTANCES	AHL_PART_CHANGES.INSTALLED_INSTANCE_ID
AHL_UC_HEADERS_H	CSI_ITEM_INSTANCES	AHL_UC_HEADERS_H.CSI_ITEM_INSTANCE_ID
AHL_UF_HEADERS	CSI_ITEM_INSTANCES	AHL_UF_HEADERS.CSI_ITEM_INSTANCE_ID
AHL_UNIT_CONFIG_HEADERS	CSI_ITEM_INSTANCES	AHL_UNIT_CONFIG_HEADERS.CSI_ITEM_INSTANCE_ID
AHL_UNIT_EFFECTIVITIES_B	CSI_ITEM_INSTANCES	AHL_UNIT_EFFECTIVITIES_B.CSI_ITEM_INSTANCE_ID
AHL_VISITS_B	CSI_ITEM_INSTANCES	AHL_VISITS_B.ITEM_INSTANCE_ID
AHL_VISIT_TASKS_B	CSI_ITEM_INSTANCES	AHL_VISIT_TASKS_B.INSTANCE_ID
CSD_MRO_SERIAL_NUMBERS	CSI_ITEM_INSTANCES	CSD_MRO_SERIAL_NUMBERS.CUSTOMER_PRODUCT_ID
CSD_REPAIRS	CSI_ITEM_INSTANCES	CSD_REPAIRS.CUSTOMER_PRODUCT_ID
CSI_IEA_VALUES	CSI_ITEM_INSTANCES	CSI_IEA_VALUES.INSTANCE_ID
CSI_II_RELATIONSHIPS	CSI_ITEM_INSTANCES	CSI_II_RELATIONSHIPS.OBJECT_ID
CSI_II_RELATIONSHIPS	CSI_ITEM_INSTANCES	CSI_II_RELATIONSHIPS.SUBJECT_ID
CSI_ITEM_INSTANCES_H	CSI_ITEM_INSTANCES	CSI_ITEM_INSTANCES_H.INSTANCE_ID
CSI_I_ASSETS	CSI_ITEM_INSTANCES	CSI_I_ASSETS.INSTANCE_ID
CSI_I_EXTENDED_ATTRIBS	CSI_ITEM_INSTANCES	CSI_I_EXTENDED_ATTRIBS.INSTANCE_ID
CSI_I_ORG_ASSIGNMENTS	CSI_ITEM_INSTANCES	CSI_I_ORG_ASSIGNMENTS.INSTANCE_ID
CSI_I_PARTIES	CSI_ITEM_INSTANCES	CSI_I_PARTIES.INSTANCE_ID
CSI_I_PRICING_ATTRIBS	CSI_ITEM_INSTANCES	CSI_I_PRICING_ATTRIBS.INSTANCE_ID
CSI_I_VERSION_LABELS	CSI_ITEM_INSTANCES	CSI_I_VERSION_LABELS.INSTANCE_ID
CSI_T_II_RELATIONSHIPS	CSI_ITEM_INSTANCES	CSI_T_II_RELATIONSHIPS.OBJECT_ID
CSI_T_TXN_LINE_DETAILS	CSI_ITEM_INSTANCES	CSI_T_TXN_LINE_DETAILS.INSTANCE_ID
CSI_T_TXN_LINE_DETAILS	CSI_ITEM_INSTANCES	CSI_T_TXN_LINE_DETAILS.CHANGED_INSTANCE_ID
CS_COUNTER_GROUPS	CSI_ITEM_INSTANCES	CS_COUNTER_GROUPS.SOURCE_OBJECT_ID
CS_INCIDENTS_ALL_B	CSI_ITEM_INSTANCES	CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID
CS_INCIDENTS_PURGE_AUDIT_B	CSI_ITEM_INSTANCES	CS_INCIDENTS_PURGE_AUDIT_B.CUSTOMER_PRODUCT_ID
OKL_TXL_ITM_INSTS	CSI_ITEM_INSTANCES	OKL_TXL_ITM_INSTS.INSTANCE_ID
OKS_SUBSCR_HEADER_B	CSI_ITEM_INSTANCES	OKS_SUBSCR_HEADER_B.INSTANCE_ID
XDP_ORDER_LINE_ITEMS	CSI_ITEM_INSTANCES	XDP_ORDER_LINE_ITEMS.IB_SOURCE_ID
XNS_CP_FES	CSI_ITEM_INSTANCES	XNS_CP_FES.CUSTOMER_PRODUCT_ID