MSC_DIM_CUST_SITE_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ID NAME CUSTOMER_NUMBER PARENT_ID DESCRIPTION KEY_CUSTOMER_TYPE |
問合せ
| SQL_Statement |
|---|
|
SELECT CUS_SITE.PARTNER_SITE_ID ID , decode(CUS_SITE.partner_id, -5, nvl(CUS_SITE.PARTNER_ADDRESS, CUS_SITE.TP_SITE_CODE), CUS_SITE.TP_SITE_CODE) NAME , CUS.PARTNER_NUMBER CUSTOMER_NUMBER, CUS_SITE.PARTNER_ID PARENT_ID , CUS_SITE.PARTNER_SITE_ID ||'-' ||CUS_SITE.TP_SITE_CODE DESCRIPTION, NVL(KC.KEY_CUSTOMER,decode(CUS_SITE.PARTNER_SITE_ID, -5 ,3, decode(CUS_SITE.PARTNER_ID, -5 ,2, 0 ) ) ) KEY_CUSTOMER_TYPE FROM MSC_CUSTOMERS_V CUS, MSC_CUSTOMER_SITES CUS_SITE, MSC_KEY_CUSTOMER KC WHERE CUS_SITE.PARTNER_TYPE = 2 AND CUS_SITE.PARTNER_TYPE = CUS.PARTNER_TYPE AND CUS.TP_ID = CUS_SITE.PARTNER_ID AND KC.CUSTOMER_ID (+) = CUS.TP_id |