VIEW: APPS.CSI_SYSTEMS_RG_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )