MSC_DIM_SOURCE_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID NAME DESCRIPTION

Query

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