[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 |