FND Design Data [Home] [Help]

Table: CS_SYSTEMS_ALL_B

Product: CS - Service
Description: Systems
Implementation/DBA Data: Not implemented in this database
Primary Key: CS_SYSTEMS_ALL_B_PK
  1. ColumnSYSTEM_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
CS_SYSTEMS_ALL_B FK Joins to TableHZ_CUST_ACCOUNTS CS_SYSTEMS_ALL_B.CUSTOMER_ID
CS_SYSTEMS_ALL_B FK Joins to TableCS_SYSTEMS_ALL_B CS_SYSTEMS_ALL_B.AUTOCREATED_FROM_SYSTEM_ID
CS_SYSTEMS_ALL_B FK Joins to TableCS_SYSTEMS_ALL_B CS_SYSTEMS_ALL_B.PARENT_SYSTEM_ID
CS_SYSTEMS_ALL_B FK Joins to TableHZ_PARTIES CS_SYSTEMS_ALL_B.TECHNICAL_CONTACT_ID
CS_SYSTEMS_ALL_B FK Joins to TableHZ_PARTIES CS_SYSTEMS_ALL_B.SERVICE_ADMIN_CONTACT_ID
CS_SYSTEMS_ALL_B FK Joins to TableHZ_PARTY_SITES CS_SYSTEMS_ALL_B.SHIP_TO_SITE_USE_ID
CS_SYSTEMS_ALL_B FK Joins to TableHZ_PARTIES CS_SYSTEMS_ALL_B.BILL_TO_CONTACT_ID
CS_SYSTEMS_ALL_B FK Joins to TableHZ_PARTY_SITES CS_SYSTEMS_ALL_B.INSTALL_SITE_USE_ID
CS_SYSTEMS_ALL_B FK Joins to TableHZ_CUST_ACCT_SITES_ALL CS_SYSTEMS_ALL_B.BILL_TO_SITE_USE_ID
CS_SYSTEMS_ALL_B FK Joins to TableHZ_PARTIES CS_SYSTEMS_ALL_B.SHIP_TO_CONTACT_ID
TableCS_CUSTOMER_PRODUCTS_ALL FK Joins to CS_SYSTEMS_ALL_B CS_CUSTOMER_PRODUCTS_ALL.SYSTEM_ID
TableCS_LINE_INST_DETAILS FK Joins to CS_SYSTEMS_ALL_B CS_LINE_INST_DETAILS.SYSTEM_ID
TableCS_SYSTEMS_ALL_B FK Joins to CS_SYSTEMS_ALL_B CS_SYSTEMS_ALL_B.AUTOCREATED_FROM_SYSTEM_ID
TableCS_SYSTEMS_ALL_B FK Joins to CS_SYSTEMS_ALL_B CS_SYSTEMS_ALL_B.PARENT_SYSTEM_ID
TableCS_SYSTEM_AUDIT FK Joins to CS_SYSTEMS_ALL_B CS_SYSTEM_AUDIT.SYSTEM_ID
TableCS_SYSTEM_AUDIT FK Joins to CS_SYSTEMS_ALL_B CS_SYSTEM_AUDIT.OLD_PARENT_SYSTEM_ID
TableCS_SYSTEM_AUDIT FK Joins to CS_SYSTEMS_ALL_B CS_SYSTEM_AUDIT.CURR_PARENT_SYSTEM_ID
TableCS_SYSTEM_AUDIT FK Joins to CS_SYSTEMS_ALL_B CS_SYSTEM_AUDIT.SYS_AUD_SYSTEM_ID
TableCS_SYSTEM_PARTY_LINKS FK Joins to CS_SYSTEMS_ALL_B CS_SYSTEM_PARTY_LINKS.SYSTEM_ID
TableCS_SYSTEM_SR_LINKS FK Joins to CS_SYSTEMS_ALL_B CS_SYSTEM_SR_LINKS.SYSTEM_ID