MSC_NK_CUST_SITE_ZONE_MAP_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ACTUAL_CUST_SITE NK_CUS_SITE_NAME PSEUDO_SITE_ID

Query

SQL_Statement
select NKV.CUS_SITE_ID ACTUAL_CUST_SITE , NKT.NK_CUS_SITE_NAME,NKT.NK_CUS_SITE_ID PSEUDO_SITE_ID from MSC_NONKEY_ZON_CUS_SITE NKT, MSC_NON_KEY_ZONE_SITE_V NKV WHERE NKT.NK_CUS_SITE_NAME = NKV.CUSTOMER_SITE_NAME