機械翻訳について

MSC_DIM_CUST_V

詳細

• スキーマ: FUSION

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

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

列

名前
ID NAME CUSTOMER_NUMBER PARENT_ID DESCRIPTION KEY_CUSTOMER_TYPE

問合せ

SQL_Statement

SELECT CUS.TP_ID ID, CUS.PARTNER_NAME NAME, CUS.PARTNER_NUMBER CUSTOMER_NUMBER, DECODE(CUS.CUSTOMER_CLASS_NAME, '-1' , -1, MSC_COLL_UTILS.GETFIXEDID('CUSTOMER_CLASS_ID',NVL(CUS.CUSTOMER_CLASS_NAME,-1),NULL)) PARENT_ID, TP_ID||'-'|| PARTNER_NUMBER DESCRIPTION, CASE CUS.TP_ID WHEN -5 THEN 2 ELSE NVL(KC.KEY_CUSTOMER,0) END AS KEY_CUSTOMER_TYPE FROM MSC_CUSTOMERS_V CUS, MSC_KEY_CUSTOMER KC ここで、CUS。 PARTNER_TYPE = 2 AND KC.CUSTOMER_ID(+) =CUS.TP_ID