View: CSI_SYSTEMS_RG_V

Product:	CSI - Install Base
Description:	Systems view for the record groups.
Implementation/DBA Data:	APPS.CSI_SYSTEMS_RG_V

View Text

SELECT CSB.SYSTEM_ID
, CST.NAME SYSTEM
, CSB.SYSTEM_NUMBER SERIAL_NUMBER
, CSB.PARENT_SYSTEM_ID
, HP.PARTY_NAME
, HCA.ACCOUNT_NUMBER
, CST.DESCRIPTION SYSTEM_DESCRIPTION
, CLK.MEANING SYSTEM_TYPE
, CSB.CUSTOMER_ID
, HCA.CUST_ACCOUNT_ID
, HCA.PARTY_ID
FROM CSI_SYSTEMS_B CSB
, CSI_SYSTEMS_TL CST
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HP
, FND_LOOKUP_VALUES CLK
WHERE CLK.LOOKUP_TYPE(+) = 'CSI_SYSTEM_TYPE' AND CSB.SYSTEM_TYPE_CODE = CLK.LOOKUP_CODE(+) AND CLK.LANGUAGE = USERENV('LANG') AND CLK.VIEW_APPLICATION_ID = 542 AND CSB.CUSTOMER_ID = HCA.CUST_ACCOUNT_ID AND HCA.PARTY_ID = HP.PARTY_ID AND CSB.SYSTEM_ID = CST.SYSTEM_ID AND CST.LANGUAGE = USERENV('LANG') AND HCA.PARTY_ID NOT IN ( SELECT INTERNAL_PARTY_ID
FROM CSI_INSTALL_PARAMETERS )

Columns