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]

View: CS_CUSTOMER_PRODUCTS_RG_V

Product:	CS - Service
Description:	This view stores information pertaining to the Products in InstalledBase
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CP.CUSTOMER_PRODUCT_ID
, CP.REFERENCE_NUMBER
, CP.CURRENT_SERIAL_NUMBER
, SI.CONCATENATED_SEGMENTS PRODUCT
, SI.DESCRIPTION PRODUCT_DESCRIPTION
, CP.QUANTITY
, CP.UNIT_OF_MEASURE_CODE
, CP.CUSTOMER_ID ACCOUNT_ID
, ACC.ACCOUNT_NUMBER
, CP.ORIGINAL_LINE_SERV_DETAIL_ID LINE_INST_DETAIL_ID
, CP.SYSTEM_ID
, CP.ORIGINAL_ORDER_LINE_ID FROM MTL_SYSTEM_ITEMS_KFV SI
, HZ_CUST_ACCOUNTS ACC
, CS_CUSTOMER_PRODUCTS CP
WHERE CP.CUSTOMER_ID = ACC.CUST_ACCOUNT_ID
AND CP.INVENTORY_ITEM_ID = SI.INVENTORY_ITEM_ID
AND SI.ORGANIZATION_ID = ( SELECT CS_STD.GET_ITEM_VALDN_ORGZN_ID
FROM DUAL )

Columns

Name
CUSTOMER_PRODUCT_ID
REFERENCE_NUMBER
CURRENT_SERIAL_NUMBER
PRODUCT
PRODUCT_DESCRIPTION
QUANTITY
UNIT_OF_MEASURE_CODE
ACCOUNT_ID
ACCOUNT_NUMBER
LINE_INST_DETAIL_ID
SYSTEM_ID
ORIGINAL_ORDER_LINE_ID