View: MSC_X_COMPANY_ORG_LOV_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.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