1. Tables and Views for SCM
  2. MSC_DIM_SUPPLIER_SITE_V

MSC_DIM_SUPPLIER_SITE_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

ID

NAME

DESCRIPTION

PARENT_ID

SUPPLIER_NAME

REFRESH_NUMBER

Query

SQL_Statement

SELECT SUP_SITE.PARTNER_SITE_ID ID ,

SUP_SITE.TP_SITE_CODE NAME ,

SUP_SITE.PARTNER_SITE_ID||'-'||SUP_SITE.TP_SITE_CODE DESCRIPTION,

SUP.TP_ID PARENT_ID ,

SUP.PARTNER_NAME SUPPLIER_NAME,

SUP_SITE.REFRESH_NUMBER REFRESH_NUMBER

FROM MSC_TRADING_PARTNER_SITES SUP_SITE,

MSC_GLOBAL_TRADING_PARTNERS SUP

WHERE SUP_SITE.PARTNER_TYPE = 1

AND SUP_SITE.PARTNER_TYPE = SUP.PARTNER_TYPE

AND SUP_SITE.PARTNER_ID = SUP.TP_ID

UNION ALL

SELECT -1000 ID,

FSS.MESSAGE_TEXT NAME,

to_char(-1000)||'-'||FSS.MESSAGE_TEXT Description,

-1000 PARENT_ID,

FS.MESSAGE_TEXT SUPPLIER_NAME,

-1 REFRESH_NUMBER

FROM FND_MESSAGES FSS, FND_MESSAGES FS

WHERE FSS.MESSAGE_NAME = 'MSC_SOP_MG_DFLT_SPLR_SITE_NAME'

AND FS.MESSAGE_NAME = 'MSC_SOP_MG_DFLT_SPLR_NAME'

AND FSS.APPLICATION_ID=724

AND FS.APPLICATION_ID=724