VIEW: APPS.MSC_X_COMPANY_ORG_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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