[Home] [Help]
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
Name |
COMPANY_SITE_ID |
COMPANY_SITE_NAME |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |