1. Tables and Views for Procurement
  2. POZ_SUPPLIERS_SIMPLE_V

POZ_SUPPLIERS_SIMPLE_V

Details

  • Schema: FUSION

  • Object owner: POZ

  • Object type: VIEW

Columns

Name

VENDOR_NAME

VENDOR_ID

SEGMENT1

DUNS_NUMBER_C

PARTY_ID

Query

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