MSC_CUSTOMER_SITES_MSC_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PARTNER_SITE_ID PARTNER_ID TP_SITE_CODE LOCATION_ID PARTNER_TYPE LAST_UPDATE_DATE TIMEZONE_CODE |
問合せ
| SQL_Statement |
|---|
|
SELECT site.PARTNER_SITE_ID, site.PARTNER_ID, site.TP_SITE_CODE, loc.LOCATION_ID, 2 PARTNER_TYPE,site.LAST_UPDATE_DATE ,site.timezone_code FROM MSC_CUSTOMER_SITES site, MSC_LOCATION_ASSOCIATIONS loc WHERE site.PARTNER_TYPE = 2 AND loc.SITE_ID = site.PARTNER_SITE_ID AND loc.SITE_TYPE = 2 |