FND Design Data [Home] [Help]

Table: CSI_SYSTEMS_B

Product: CSI - Install Base
Description: System Details ( Base Table)
Implementation/DBA Data: TableCSI.CSI_SYSTEMS_B
Primary Key: CSI_SYSTEMS_B_PK
  1. ColumnSYSTEM_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
CSI_SYSTEMS_B FK Joins to TableHZ_CUST_ACCOUNTS CSI_SYSTEMS_B.CUSTOMER_ID
CSI_SYSTEMS_B FK Joins to TableCSI_SYSTEMS_B CSI_SYSTEMS_B.AUTOCREATED_FROM_SYSTEM_ID
CSI_SYSTEMS_B FK Joins to TableCSI_SYSTEMS_B CSI_SYSTEMS_B.PARENT_SYSTEM_ID
CSI_SYSTEMS_B FK Joins to TableHZ_PARTIES CSI_SYSTEMS_B.BILL_TO_CONTACT_ID
CSI_SYSTEMS_B FK Joins to TableHZ_PARTIES CSI_SYSTEMS_B.SHIP_TO_CONTACT_ID
CSI_SYSTEMS_B FK Joins to TableHZ_PARTIES CSI_SYSTEMS_B.TECHNICAL_CONTACT_ID
CSI_SYSTEMS_B FK Joins to TableHZ_PARTIES CSI_SYSTEMS_B.SERVICE_ADMIN_CONTACT_ID
CSI_SYSTEMS_B FK Joins to TableHZ_CUST_SITE_USES_ALL CSI_SYSTEMS_B.SHIP_TO_SITE_USE_ID
CSI_SYSTEMS_B FK Joins to TableHZ_PARTY_SITES CSI_SYSTEMS_B.INSTALL_SITE_USE_ID
CSI_SYSTEMS_B FK Joins to TableHZ_CUST_SITE_USES_ALL CSI_SYSTEMS_B.BILL_TO_SITE_USE_ID
TableCSI_ITEM_INSTANCES FK Joins to CSI_SYSTEMS_B CSI_ITEM_INSTANCES.SYSTEM_ID
TableCSI_SYSTEMS_B FK Joins to CSI_SYSTEMS_B CSI_SYSTEMS_B.AUTOCREATED_FROM_SYSTEM_ID
TableCSI_SYSTEMS_B FK Joins to CSI_SYSTEMS_B CSI_SYSTEMS_B.PARENT_SYSTEM_ID
TableCSI_SYSTEMS_H FK Joins to CSI_SYSTEMS_B CSI_SYSTEMS_H.SYSTEM_ID
TableCSI_T_TXN_LINE_DETAILS FK Joins to CSI_SYSTEMS_B CSI_T_TXN_LINE_DETAILS.CSI_SYSTEM_ID
TableCS_INCIDENTS_ALL_B FK Joins to CSI_SYSTEMS_B CS_INCIDENTS_ALL_B.SYSTEM_ID