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_SYSTEMS_RG_V

Product:	CS - Service
Description:	System Information
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT A.SYSTEM_ID
, A.NAME SYSTEM
, A.SERIAL_NUMBER
, A.PARENT_SYSTEM_ID
, C.PARTY_NAME
, B.ACCOUNT_NUMBER
, A.DESCRIPTION SYSTEM_DESCRIPTION
, LK.MEANING SYSTEM_TYPE
, A.CUSTOMER_ID
, B.CUST_ACCOUNT_ID
, B.PARTY_ID
FROM CS_SYSTEMS A
, HZ_CUST_ACCOUNTS B
, HZ_PARTIES C
, CS_LOOKUPS LK
WHERE LK.LOOKUP_TYPE(+) = 'SYSTEM_TYPE'
AND A.SYSTEM_TYPE_CODE = LK.LOOKUP_CODE(+)
AND A.CUSTOMER_ID = B.CUST_ACCOUNT_ID
AND B.PARTY_ID = C.PARTY_ID

Columns

Name
SYSTEM_ID
SYSTEM
SERIAL_NUMBER
PARENT_SYSTEM_ID
PARTY_NAME
ACCOUNT_NUMBER
SYSTEM_DESCRIPTION
SYSTEM_TYPE
CUSTOMER_ID
CUST_ACCOUNT_ID
PARTY_ID