[Home] [Help]
View: MSC_X_COMPANY_ORG_LOV_V
View Text
SELECT DECODE(1
, 1
, COMPANY_NAME || '(' || COMPANY_SITE_NAME || ')')
, COMPANY_NAME
, COMPANY_SITE_NAME
FROM MSC_COMPANIES CM
, MSC_COMPANY_SITES SITES
WHERE CM.COMPANY_ID = SITES.COMPANY_ID
Columns
Name |
COMPANY_ORG |
COMPANY_NAME |
COMPANY_SITE_NAME |