1. Tables and Views for SCM
  2. MSC_AP_SUPPLIERS_V

MSC_AP_SUPPLIERS_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

SR_TP_ID

PARTNER_NAME

PARTNER_NUMBER

PARTY_ID

ENABLED_FLAG

START_DATE_ACTIVE

PARTNER_TYPE

DISABLE_DATE

POZ_ROWID

HZ_ROWID

Query

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