View: CSI_CP_SYSTEMS_RG_V

Product:	CSI - Install Base
Description:	Backward Compatible : Customer Product - Systems Record Groups.
Implementation/DBA Data:	APPS.CSI_CP_SYSTEMS_RG_V

View Text

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)

Columns