View: MSC_X_ORGS_LOV_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_X_ORGS_LOV_V

View Text

SELECT CS.COMPANY_SITE_ID
, CS.COMPANY_SITE_NAME
, CS.LAST_UPDATE_DATE
, CS.LAST_UPDATED_BY
FROM MSC_COMPANY_SITES CS
WHERE CS.COMPANY_ID = DECODE(MSCX_UI_UTILITIES.GET_RESPONSIBILITY_KEY
, 'MSCX_SC_ADMIN_FULL'
, CS.COMPANY_ID
, SYS_CONTEXT('MSC'
, 'COMPANY_ID'))

Columns