FND Design Data [Home] [Help]

Table: CSI_ITEM_INSTANCES

Product: CSI - Install Base
Description: Item Instance details.
Implementation/DBA Data: TableCSI.CSI_ITEM_INSTANCES
Primary Key: CSI_ITEM_INSTANCES_PK
  1. ColumnINSTANCE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
CSI_ITEM_INSTANCES FK Joins to TableMTL_SYSTEM_ITEMS_B CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID
CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID
CSI_ITEM_INSTANCES FK Joins to TableMTL_ITEM_REVISIONS_B CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID
CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID
CSI_ITEM_INSTANCES.INVENTORY_REVISION
CSI_ITEM_INSTANCES FK Joins to TableMTL_SERIAL_NUMBERS CSI_ITEM_INSTANCES.SERIAL_NUMBER
CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID
CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID
CSI_ITEM_INSTANCES FK Joins to TableMTL_LOT_NUMBERS CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID
CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID
CSI_ITEM_INSTANCES.LOT_NUMBER
CSI_ITEM_INSTANCES FK Joins to TableMTL_MATERIAL_STATUSES_B CSI_ITEM_INSTANCES.INSTANCE_CONDITION_ID
CSI_ITEM_INSTANCES FK Joins to TableCSI_INSTANCE_STATUSES CSI_ITEM_INSTANCES.INSTANCE_STATUS_ID
CSI_ITEM_INSTANCES FK Joins to TableCSI_SYSTEMS_B CSI_ITEM_INSTANCES.SYSTEM_ID
CSI_ITEM_INSTANCES FK Joins to TableHZ_PARTY_SITES CSI_ITEM_INSTANCES.LOCATION_ID
CSI_ITEM_INSTANCES FK Joins to TablePA_PROJECTS_ALL CSI_ITEM_INSTANCES.PA_PROJECT_ID
CSI_ITEM_INSTANCES FK Joins to TablePA_TASKS CSI_ITEM_INSTANCES.PA_PROJECT_TASK_ID
CSI_ITEM_INSTANCES FK Joins to TableOE_ORDER_LINES_ALL CSI_ITEM_INSTANCES.IN_TRANSIT_ORDER_LINE_ID
CSI_ITEM_INSTANCES FK Joins to TableWIP_DISCRETE_JOBS CSI_ITEM_INSTANCES.WIP_JOB_ID
CSI_ITEM_INSTANCES FK Joins to TablePO_LINES_ALL CSI_ITEM_INSTANCES.PO_ORDER_LINE_ID
TableAHL_PART_CHANGES FK Joins to CSI_ITEM_INSTANCES AHL_PART_CHANGES.REMOVED_INSTANCE_ID
TableAHL_PART_CHANGES FK Joins to CSI_ITEM_INSTANCES AHL_PART_CHANGES.INSTALLED_INSTANCE_ID
TableAHL_PRD_DISPOSITIONS_B FK Joins to CSI_ITEM_INSTANCES AHL_PRD_DISPOSITIONS_B.INSTANCE_ID
TableAHL_PRD_DISPOSITIONS_B_H FK Joins to CSI_ITEM_INSTANCES AHL_PRD_DISPOSITIONS_B_H.INSTANCE_ID
TableAHL_UC_HEADERS_H FK Joins to CSI_ITEM_INSTANCES AHL_UC_HEADERS_H.CSI_ITEM_INSTANCE_ID
TableAHL_UF_HEADERS FK Joins to CSI_ITEM_INSTANCES AHL_UF_HEADERS.CSI_ITEM_INSTANCE_ID
TableAHL_UNIT_CONFIG_HEADERS FK Joins to CSI_ITEM_INSTANCES AHL_UNIT_CONFIG_HEADERS.CSI_ITEM_INSTANCE_ID
TableAHL_UNIT_EFFECTIVITIES_B FK Joins to CSI_ITEM_INSTANCES AHL_UNIT_EFFECTIVITIES_B.CSI_ITEM_INSTANCE_ID
TableAHL_VISITS_B FK Joins to CSI_ITEM_INSTANCES AHL_VISITS_B.ITEM_INSTANCE_ID
TableAHL_VISIT_TASKS_B FK Joins to CSI_ITEM_INSTANCES AHL_VISIT_TASKS_B.INSTANCE_ID
TableAHL_WARRANTY_CONTRACTS_B FK Joins to CSI_ITEM_INSTANCES AHL_WARRANTY_CONTRACTS_B.ITEM_INSTANCE_ID
TableCSD_MRO_SERIAL_NUMBERS FK Joins to CSI_ITEM_INSTANCES CSD_MRO_SERIAL_NUMBERS.CUSTOMER_PRODUCT_ID
TableCSD_REPAIRS FK Joins to CSI_ITEM_INSTANCES CSD_REPAIRS.CUSTOMER_PRODUCT_ID
TableCSI_IEA_VALUES FK Joins to CSI_ITEM_INSTANCES CSI_IEA_VALUES.INSTANCE_ID
TableCSI_II_RELATIONSHIPS FK Joins to CSI_ITEM_INSTANCES CSI_II_RELATIONSHIPS.OBJECT_ID
TableCSI_II_RELATIONSHIPS FK Joins to CSI_ITEM_INSTANCES CSI_II_RELATIONSHIPS.SUBJECT_ID
TableCSI_ITEM_INSTANCES_H FK Joins to CSI_ITEM_INSTANCES CSI_ITEM_INSTANCES_H.INSTANCE_ID
TableCSI_I_ASSETS FK Joins to CSI_ITEM_INSTANCES CSI_I_ASSETS.INSTANCE_ID
TableCSI_I_EXTENDED_ATTRIBS FK Joins to CSI_ITEM_INSTANCES CSI_I_EXTENDED_ATTRIBS.INSTANCE_ID
TableCSI_I_ORG_ASSIGNMENTS FK Joins to CSI_ITEM_INSTANCES CSI_I_ORG_ASSIGNMENTS.INSTANCE_ID
TableCSI_I_PARTIES FK Joins to CSI_ITEM_INSTANCES CSI_I_PARTIES.INSTANCE_ID
TableCSI_I_PRICING_ATTRIBS FK Joins to CSI_ITEM_INSTANCES CSI_I_PRICING_ATTRIBS.INSTANCE_ID
TableCSI_I_VERSION_LABELS FK Joins to CSI_ITEM_INSTANCES CSI_I_VERSION_LABELS.INSTANCE_ID
TableCSI_T_II_RELATIONSHIPS FK Joins to CSI_ITEM_INSTANCES CSI_T_II_RELATIONSHIPS.OBJECT_ID
TableCSI_T_TXN_LINE_DETAILS FK Joins to CSI_ITEM_INSTANCES CSI_T_TXN_LINE_DETAILS.INSTANCE_ID
TableCSI_T_TXN_LINE_DETAILS FK Joins to CSI_ITEM_INSTANCES CSI_T_TXN_LINE_DETAILS.CHANGED_INSTANCE_ID
TableCS_COUNTER_GROUPS FK Joins to CSI_ITEM_INSTANCES CS_COUNTER_GROUPS.SOURCE_OBJECT_ID
TableCS_INCIDENTS_ALL_B FK Joins to CSI_ITEM_INSTANCES CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID
TableCS_INCIDENTS_PURGE_AUDIT_B FK Joins to CSI_ITEM_INSTANCES CS_INCIDENTS_PURGE_AUDIT_B.CUSTOMER_PRODUCT_ID
TableOKL_TXL_ITM_INSTS FK Joins to CSI_ITEM_INSTANCES OKL_TXL_ITM_INSTS.INSTANCE_ID
TableOKS_SUBSCR_HEADER_B FK Joins to CSI_ITEM_INSTANCES OKS_SUBSCR_HEADER_B.INSTANCE_ID
TableXDP_ORDER_LINE_ITEMS FK Joins to CSI_ITEM_INSTANCES XDP_ORDER_LINE_ITEMS.IB_SOURCE_ID
TableXNS_CP_FES FK Joins to CSI_ITEM_INSTANCES XNS_CP_FES.CUSTOMER_PRODUCT_ID