MSC_DIM_SOURCE_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ID NAME DESCRIPTION |
問合せ
| SQL_Statement |
|---|
|
SELECT SUP_SITE.PARTNER_SITE_ID ID, SUP.PARTNER_NAME||':'||SUP_SITE.TP_SITE_CODE NAME, SUP.PARTNER_NAME||':'||SUP_SITE.TP_SITE_CODE DESCRIPTION FROM MSC_TRADING_PARTNER_SITES SUP_SITE, MSC_GLOBAL_TRADING_PARTNERS SUP WHERE SUP_SITE.PARTNER_TYPE = 1 AND SUP_SITE.PARTNER_ID = SUP.TP_ID union all select MEMBER_ID ID,NAME,NAME DESCRIPTION from MSC_SOURCE_LEVEL_MEMBERS |