HZ_CUSTOMER_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: HZ
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PARTY_ID PARTY_NUMBER |
問合せ
| SQL_Statement |
|---|
|
SELECT HP.PARTY_ID,HP.PARTY_NUMBER FROM HZ_PARTIES HP, HZ_PARTY_USG_ASSIGNMENTS PUA WHERE HP.PARTY_ID = PUA.PARTY_ID AND PUA.PARTY_USAGE_CODE IN ('CUSTOMER' ,'SALES_ACCOUNT', 'SALES_PROSPECT','LEGAL_ENTITY','EXTERNAL_LEGAL_ENTITY') |