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.

VIEW: APPS.CSI_CP_SYSTEMS_RG_V

Source

View Text - Preformatted


SELECT CSV.SYSTEM_ID , CSV.NAME SYSTEM , CSV.SYSTEM_NUMBER , CSV.PARENT_SYSTEM_ID, HP.PARTY_NAME , HCA.ACCOUNT_NUMBER , CSV.DESCRIPTION, CL.MEANING, CSV.CUSTOMER_ID, HCA.CUST_ACCOUNT_ID , HP.PARTY_ID FROM CSI_SYSTEMS_VL CSV, HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP, CSI_LOOKUPS CL WHERE CL.LOOKUP_TYPE(+) = 'SYSTEM_TYPE' AND CSV.SYSTEM_TYPE_CODE = CL.LOOKUP_CODE(+) AND CSV.CUSTOMER_ID = HCA.CUST_ACCOUNT_ID AND HP.PARTY_ID = HCA.PARTY_ID AND NOT EXISTS (SELECT 1 FROM CSI_INSTALL_PARAMETERS CIPM WHERE CIPM.INTERNAL_PARTY_ID = CSV.CUSTOMER_ID)

View Text - HTML Formatted

SELECT CSV.SYSTEM_ID
, CSV.NAME SYSTEM
, CSV.SYSTEM_NUMBER
, CSV.PARENT_SYSTEM_ID
, HP.PARTY_NAME
, HCA.ACCOUNT_NUMBER
, CSV.DESCRIPTION
, CL.MEANING
, CSV.CUSTOMER_ID
, HCA.CUST_ACCOUNT_ID
, HP.PARTY_ID
FROM CSI_SYSTEMS_VL CSV
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HP
, CSI_LOOKUPS CL
WHERE CL.LOOKUP_TYPE(+) = 'SYSTEM_TYPE'
AND CSV.SYSTEM_TYPE_CODE = CL.LOOKUP_CODE(+)
AND CSV.CUSTOMER_ID = HCA.CUST_ACCOUNT_ID
AND HP.PARTY_ID = HCA.PARTY_ID
AND NOT EXISTS (SELECT 1
FROM CSI_INSTALL_PARAMETERS CIPM
WHERE CIPM.INTERNAL_PARTY_ID = CSV.CUSTOMER_ID)