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