機械翻訳について

MSC_DIM_CUS_GEO_CUS_SITE_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: MSC

• オブジェクト・タイプ: VIEW

列

名前
ID NAME DESCRIPTION PARENT_ID

問合せ

SQL_Statement

SELECT DISTINCT CSV.PARTNER_SITE_ID ID , CSV.TP_SITE_CODE NAME , CSV.PARTNER_SITE_ID||'-'|| CSV.TP_SITE_CODE DESCRIPTION , MR.REGION_ID PARENT_ID FROM MSC_REGIONS_V MR, MSC_LOCATIONS_V ML, MSC_LOC_ASSOCIATIONS_V LA, MSC_CUSTOMER_SITES_V CSV WHERE MR.REGION_LEVEL = (SELECT MAX(REGION_LEVEL) FROM MSC_REGIONS_V WHERE COUNTRY_CODE = MR.COUNTRY_CODE ) AND MR.REGION_ID = ML.REGION_ID AND ML.LOCATION_ID = LA.LOCATION_ID AND LA.SITE_ID = CSV.PARTNER_SITE_ID AND LA.SITE_TYPE = 2