MSC_AP_SUPPLIERS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
SR_TP_ID PARTNER_NAME PARTNER_NUMBER PARTY_ID ENABLED_FLAG START_DATE_ACTIVE PARTNER_TYPE DISABLE_DATE POZ_ROWID HZ_ROWID |
問合せ
| SQL_Statement |
|---|
|
SELECT v.vendor_id sr_tp_id, hp.party_name partner_name, v.segment1 partner_number, hp.party_id, (case when v.end_date_active is not null and v.end_date_active < sysdate then 'N' else 'Y' end ) enabled_flag, v.start_date_active, 1 partner_type, v.end_date_active disable_date, v.rowid poz_rowid, hp.rowid hz_rowid FROM poz_suppliers v, hz_parties hp WHERE hp.party_id = v.party_id |