[Home] [Help]
View: CS_SYSTEMS_FIND_V
| Product: | CS - Service |
|---|
| Description: | View Table for System Id field in find block |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT /*+ FIRST_ROWS */ CS.NAME
, CS.SYSTEM_ID
, CS.ORG_ID
, HR.NAME ORG_NAME
, CS.DESCRIPTION
, HZACCT.ACCOUNT_NUMBER
, CS.SERIAL_NUMBER
FROM CS_SYSTEMS_ALL_VL CS
, HZ_CUST_ACCOUNTS HZACCT
, HR_ALL_ORGANIZATION_UNITS HR
WHERE CS.CUSTOMER_ID = HZACCT.CUST_ACCOUNT_ID
AND CS.ORG_ID = HR.ORGANIZATION_ID
AND EXISTS (SELECT 'X'
FROM CS_CUST_PROD_FORM_V CCP
WHERE CCP.SYSTEM_ID = CS.SYSTEM_ID)
Columns
| Name |
| NAME |
| SYSTEM_ID |
| ORG_ID |
| ORG_NAME |
| DESCRIPTION |
| ACCOUNT_NUMBER |
| SERIAL_NUMBER |