POZ_SUPPLIERS_SIMPLE_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: POZ
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
VENDOR_NAME VENDOR_ID SEGMENT1 DUNS_NUMBER_C PARTY_ID |
問合せ
| SQL_Statement |
|---|
|
SELECT tca_party.party_name VENDOR_NAME, poz_vendor.VENDOR_ID, poz_vendor.SEGMENT1, tca_party.DUNS_NUMBER_C, poz_vendor.PARTY_ID FROM POZ_SUPPLIERS poz_vendor, HZ_PARTIES tca_party WHERE tca_party.party_id = poz_vendor.party_id |