機械翻訳について

MSC_CUSTOMERS_TCA_V

詳細

• スキーマ: FUSION

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

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

列

名前
PARTNER_NAME PARTNER_NUMBER STATUS PARTNER_TYPE TP_ID LAST_UPDATE_DATE CUSTOMER_CLASS_NAME

問合せ

SQL_Statement
SELECT HP.PARTY_NAME PARTNER_NAME, HP.PARTY_NUMBER PARTNER_NUMBER, DECODE (HP.STATUS,'A', 1,'I', 2, NULL) STATUS, 2 PARTNER_TYPE, HP.PARTY_ID TP_ID,HP.LAST_UPDATE_DATE,NVL(HP.CATEGORY_CODE,-1) CUSTOMER_CLASS_NAME FROM HZ_PARTIES HP WHERE EXISTS (SELECT 1 FROM HZ_CUST_ACCOUNTS HCA WHERE HCA.PARTY_ID = HP.PARTY_ID)