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: CS_CUSTOMER_PRODUCTS_ALL

Product:	CS - Service
Description:	The Customer installed base Products information.
Implementation/DBA Data:	Not implemented in this database

Primary Key: CS_CUSTOMER_PRODUCTS_PK

CUSTOMER_PRODUCT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
CS_CUSTOMER_PRODUCTS_ALL	HZ_PARTY_SITES	CS_CUSTOMER_PRODUCTS_ALL.SHIP_TO_SITE_USE_ID
CS_CUSTOMER_PRODUCTS_ALL	CS_CUSTOMER_PRODUCTS_ALL	CS_CUSTOMER_PRODUCTS_ALL.PARENT_CP_ID
CS_CUSTOMER_PRODUCTS_ALL	CS_CUSTOMER_PRODUCT_STATUSES	CS_CUSTOMER_PRODUCTS_ALL.CUSTOMER_PRODUCT_STATUS_ID
CS_CUSTOMER_PRODUCTS_ALL	CS_CUSTOMER_PRODUCTS_ALL	CS_CUSTOMER_PRODUCTS_ALL.CONFIG_PARENT_ID
CS_CUSTOMER_PRODUCTS_ALL	CS_CUSTOMER_PRODUCTS_ALL	CS_CUSTOMER_PRODUCTS_ALL.CONFIG_ROOT_ID
CS_CUSTOMER_PRODUCTS_ALL	HZ_CUST_ACCOUNTS	CS_CUSTOMER_PRODUCTS_ALL.CUSTOMER_ID
CS_CUSTOMER_PRODUCTS_ALL	CS_LINE_INST_DETAILS	CS_CUSTOMER_PRODUCTS_ALL.ORIGINAL_LINE_SERV_DETAIL_ID
CS_CUSTOMER_PRODUCTS_ALL	HZ_PARTY_SITES	CS_CUSTOMER_PRODUCTS_ALL.INSTALL_SITE_USE_ID
CS_CUSTOMER_PRODUCTS_ALL	HZ_CUST_ACCT_SITES_ALL	CS_CUSTOMER_PRODUCTS_ALL.BILL_TO_SITE_USE_ID
CS_CUSTOMER_PRODUCTS_ALL	CS_CP_REVISIONS	CS_CUSTOMER_PRODUCTS_ALL.CURRENT_CP_REVISION_ID
CS_CUSTOMER_PRODUCTS_ALL	%	CS_CUSTOMER_PRODUCTS_ALL.PLATFORM_VERSION_ID
CS_CUSTOMER_PRODUCTS_ALL	CS_SYSTEMS_ALL_B	CS_CUSTOMER_PRODUCTS_ALL.SYSTEM_ID
CS_CUSTOMER_PRODUCTS_ALL	MTL_ITEM_REVISIONS_B	CS_CUSTOMER_PRODUCTS_ALL.MIB_INVENTORY_ITEM_ID CS_CUSTOMER_PRODUCTS_ALL.MIB_ORGANIZATION_ID CS_CUSTOMER_PRODUCTS_ALL.MIB_REVISION_ID
CSD_REPAIRS	CS_CUSTOMER_PRODUCTS_ALL	CSD_REPAIRS.CUSTOMER_PRODUCT_ID
CS_CONTACTS	CS_CUSTOMER_PRODUCTS_ALL	CS_CONTACTS.SOURCE_OBJECT_ID
CS_CP_LANGUAGES	CS_CUSTOMER_PRODUCTS_ALL	CS_CP_LANGUAGES.CUSTOMER_PRODUCT_ID
CS_CP_PARAMETERS	CS_CUSTOMER_PRODUCTS_ALL	CS_CP_PARAMETERS.CUSTOMER_PRODUCT_ID
CS_CP_REVISIONS	CS_CUSTOMER_PRODUCTS_ALL	CS_CP_REVISIONS.CUSTOMER_PRODUCT_ID
CS_CUSTOMER_PRODUCTS_ALL	CS_CUSTOMER_PRODUCTS_ALL	CS_CUSTOMER_PRODUCTS_ALL.PARENT_CP_ID
CS_CUSTOMER_PRODUCTS_ALL	CS_CUSTOMER_PRODUCTS_ALL	CS_CUSTOMER_PRODUCTS_ALL.CONFIG_PARENT_ID
CS_CUSTOMER_PRODUCTS_ALL	CS_CUSTOMER_PRODUCTS_ALL	CS_CUSTOMER_PRODUCTS_ALL.CONFIG_ROOT_ID
CS_ESTIMATE_DETAILS	CS_CUSTOMER_PRODUCTS_ALL	CS_ESTIMATE_DETAILS.CUSTOMER_PRODUCT_ID
CS_INCIDENTS_ALL_B	CS_CUSTOMER_PRODUCTS_ALL	CS_INCIDENTS_ALL_B.CP_COMPONENT_ID
CS_INCIDENTS_ALL_B	CS_CUSTOMER_PRODUCTS_ALL	CS_INCIDENTS_ALL_B.CP_SUBCOMPONENT_ID
CS_LINE_INST_DETAILS	CS_CUSTOMER_PRODUCTS_ALL	CS_LINE_INST_DETAILS.CUSTOMER_PRODUCT_ID