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'))
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'))
|
|
|