[Home] [Help]
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
Name |
SYSTEM_ID |
SYSTEM |
SERIAL_NUMBER |
PARENT_SYSTEM_ID |
PARTY_NAME |
ACCOUNT_NUMBER |
SYSTEM_DESCRIPTION |
SYSTEM_TYPE |
CUSTOMER_ID |
CUST_ACCOUNT_ID |
PARTY_ID |