POZ_SUPPLIER_SITES

Details

Schema: FUSION
Object owner: POZ
Object type: VIEW

Columns

Name
VENDOR_SITE_SPK_ID VENDOR_SITE_ID EFFECTIVE_END_DATE EFFECTIVE_START_DATE EFFECTIVE_SEQUENCE OBJECT_VERSION_NUMBER INACTIVE_DATE VENDOR_ID PRC_BU_ID LOCATION_ID PARTY_SITE_ID VENDOR_SITE_CODE PURCHASING_SITE_FLAG RFQ_ONLY_SITE_FLAG PAY_SITE_FLAG TP_HEADER_ID SERVICES_TOLERANCE_ID TOLERANCE_ID TERMS_ID EXCLUDE_FREIGHT_FROM_DISCOUNT BANK_CHARGE_BEARER PAY_ON_CODE DEFAULT_PAY_SITE_ID PAY_ON_RECEIPT_SUMMARY_CODE ECE_TP_LOCATION_CODE PCARD_SITE_FLAG MATCH_OPTION COUNTRY_OF_ORIGIN_CODE CREATE_DEBIT_MEMO_FLAG SUPPLIER_NOTIF_METHOD EMAIL_ADDRESS PRIMARY_PAY_SITE_FLAG SHIPPING_CONTROL SELLING_COMPANY_IDENTIFIER GAPLESS_INV_NUM_FLAG RETAINAGE_RATE AUTO_CALCULATE_INTEREST_FLAG HOLD_BY HOLD_DATE HOLD_FLAG PURCHASING_HOLD_REASON VENDOR_SITE_CODE_ALT ATTENTION_AR_FLAG AREA_CODE PHONE CUSTOMER_NUM SHIP_VIA_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE FOB_LOOKUP_CODE FAX FAX_AREA_CODE TELEX TERMS_DATE_BASIS PAY_GROUP_LOOKUP_CODE PAYMENT_PRIORITY INVOICE_AMOUNT_LIMIT PAY_DATE_BASIS_LOOKUP_CODE ALWAYS_TAKE_DISC_FLAG INVOICE_CURRENCY_CODE PAYMENT_CURRENCY_CODE HOLD_ALL_PAYMENTS_FLAG HOLD_FUTURE_PAYMENTS_FLAG HOLD_REASON HOLD_UNMATCHED_INVOICES_FLAG PAYMENT_HOLD_DATE TAX_REPORTING_SITE_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE_CATEGORY CARRIER_ID ALLOW_SUBSTITUTE_RECEIPTS_FLAG ALLOW_UNORDERED_RECEIPTS_FLAG ENFORCE_SHIP_TO_LOCATION_CODE QTY_RCV_EXCEPTION_CODE RECEIPT_DAYS_EXCEPTION_CODE INSPECTION_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG QTY_RCV_TOLERANCE DAYS_EARLY_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED RECEIVING_ROUTING_ID SHIPPING_NETWORK_LOCATION PHONE_COUNTRY_CODE PHONE_EXTENSION FAX_COUNTRY_CODE TAX_COUNTRY_CODE ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE_DATE1 ATTRIBUTE_DATE10 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP10 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP9 GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE10 GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_DATE6 GLOBAL_ATTRIBUTE_DATE7 GLOBAL_ATTRIBUTE_DATE8 GLOBAL_ATTRIBUTE_DATE9 GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER10 GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER5 GLOBAL_ATTRIBUTE_NUMBER6 GLOBAL_ATTRIBUTE_NUMBER7 GLOBAL_ATTRIBUTE_NUMBER8 GLOBAL_ATTRIBUTE_NUMBER9 GLOBAL_ATTRIBUTE_TIMESTAMP1 GLOBAL_ATTRIBUTE_TIMESTAMP10 GLOBAL_ATTRIBUTE_TIMESTAMP2 GLOBAL_ATTRIBUTE_TIMESTAMP3 GLOBAL_ATTRIBUTE_TIMESTAMP4 GLOBAL_ATTRIBUTE_TIMESTAMP5 GLOBAL_ATTRIBUTE_TIMESTAMP6 GLOBAL_ATTRIBUTE_TIMESTAMP7 GLOBAL_ATTRIBUTE_TIMESTAMP8 GLOBAL_ATTRIBUTE_TIMESTAMP9 AGING_PERIOD_DAYS AGING_ONSET_POINT CONSUMPTION_ADVICE_FREQUENCY CONSUMPTION_ADVICE_SUMMARY PAY_ON_USE_FLAG MODE_OF_TRANSPORT SERVICE_LEVEL ADDRESS_LINE1 ADDRESS_LINE2 ADDRESS_LINE3 ADDRESS_LINE4 ADDRESS_STYLE ADDRESS_LINES_ALT CITY STATE COUNTY COUNTRY ZIP PROVINCE LANGUAGE_CODE DUNS_NUMBER PARTY_SITE_NAME BUILDING FLOOR_NUMBER ADDR_ELEMENT_ATTRIBUTE1 ADDR_ELEMENT_ATTRIBUTE2 ADDR_ELEMENT_ATTRIBUTE3 ADDR_ELEMENT_ATTRIBUTE4 ADDR_ELEMENT_ATTRIBUTE5 POSTAL_PLUS4_CODE

Name

VENDOR_SITE_SPK_ID

VENDOR_SITE_ID

EFFECTIVE_END_DATE

EFFECTIVE_START_DATE

EFFECTIVE_SEQUENCE

OBJECT_VERSION_NUMBER

INACTIVE_DATE

VENDOR_ID

PRC_BU_ID

LOCATION_ID

PARTY_SITE_ID

VENDOR_SITE_CODE

PURCHASING_SITE_FLAG

RFQ_ONLY_SITE_FLAG

PAY_SITE_FLAG

TP_HEADER_ID

SERVICES_TOLERANCE_ID

TOLERANCE_ID

TERMS_ID

EXCLUDE_FREIGHT_FROM_DISCOUNT

BANK_CHARGE_BEARER

PAY_ON_CODE

DEFAULT_PAY_SITE_ID

PAY_ON_RECEIPT_SUMMARY_CODE

ECE_TP_LOCATION_CODE

PCARD_SITE_FLAG

MATCH_OPTION

COUNTRY_OF_ORIGIN_CODE

CREATE_DEBIT_MEMO_FLAG

SUPPLIER_NOTIF_METHOD

EMAIL_ADDRESS

PRIMARY_PAY_SITE_FLAG

SHIPPING_CONTROL

SELLING_COMPANY_IDENTIFIER

GAPLESS_INV_NUM_FLAG

RETAINAGE_RATE

AUTO_CALCULATE_INTEREST_FLAG

HOLD_BY

HOLD_DATE

HOLD_FLAG

PURCHASING_HOLD_REASON

VENDOR_SITE_CODE_ALT

ATTENTION_AR_FLAG

AREA_CODE

PHONE

CUSTOMER_NUM

SHIP_VIA_LOOKUP_CODE

FREIGHT_TERMS_LOOKUP_CODE

FOB_LOOKUP_CODE

FAX

FAX_AREA_CODE

TELEX

TERMS_DATE_BASIS

PAY_GROUP_LOOKUP_CODE

PAYMENT_PRIORITY

INVOICE_AMOUNT_LIMIT

PAY_DATE_BASIS_LOOKUP_CODE

ALWAYS_TAKE_DISC_FLAG

INVOICE_CURRENCY_CODE

PAYMENT_CURRENCY_CODE

HOLD_ALL_PAYMENTS_FLAG

HOLD_FUTURE_PAYMENTS_FLAG

HOLD_REASON

HOLD_UNMATCHED_INVOICES_FLAG

PAYMENT_HOLD_DATE

TAX_REPORTING_SITE_FLAG

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATION_DATE

CREATED_BY

REQUEST_ID

PROGRAM_APPLICATION_ID

PROGRAM_ID

PROGRAM_UPDATE_DATE

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

GLOBAL_ATTRIBUTE1

GLOBAL_ATTRIBUTE2

GLOBAL_ATTRIBUTE3

GLOBAL_ATTRIBUTE4

GLOBAL_ATTRIBUTE5

GLOBAL_ATTRIBUTE6

GLOBAL_ATTRIBUTE7

GLOBAL_ATTRIBUTE8

GLOBAL_ATTRIBUTE9

GLOBAL_ATTRIBUTE10

GLOBAL_ATTRIBUTE11

GLOBAL_ATTRIBUTE12

GLOBAL_ATTRIBUTE13

GLOBAL_ATTRIBUTE14

GLOBAL_ATTRIBUTE15

GLOBAL_ATTRIBUTE16

GLOBAL_ATTRIBUTE17

GLOBAL_ATTRIBUTE18

GLOBAL_ATTRIBUTE19

GLOBAL_ATTRIBUTE20

GLOBAL_ATTRIBUTE_CATEGORY

CARRIER_ID

ALLOW_SUBSTITUTE_RECEIPTS_FLAG

ALLOW_UNORDERED_RECEIPTS_FLAG

ENFORCE_SHIP_TO_LOCATION_CODE

QTY_RCV_EXCEPTION_CODE

RECEIPT_DAYS_EXCEPTION_CODE

INSPECTION_REQUIRED_FLAG

RECEIPT_REQUIRED_FLAG

QTY_RCV_TOLERANCE

DAYS_EARLY_RECEIPT_ALLOWED

DAYS_LATE_RECEIPT_ALLOWED

RECEIVING_ROUTING_ID

SHIPPING_NETWORK_LOCATION

PHONE_COUNTRY_CODE

PHONE_EXTENSION

FAX_COUNTRY_CODE

TAX_COUNTRY_CODE

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE_DATE1

ATTRIBUTE_DATE10

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER10

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP10

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

ATTRIBUTE_TIMESTAMP6

ATTRIBUTE_TIMESTAMP7

ATTRIBUTE_TIMESTAMP8

ATTRIBUTE_TIMESTAMP9

GLOBAL_ATTRIBUTE_DATE1

GLOBAL_ATTRIBUTE_DATE10

GLOBAL_ATTRIBUTE_DATE2

GLOBAL_ATTRIBUTE_DATE3

GLOBAL_ATTRIBUTE_DATE4

GLOBAL_ATTRIBUTE_DATE5

GLOBAL_ATTRIBUTE_DATE6

GLOBAL_ATTRIBUTE_DATE7

GLOBAL_ATTRIBUTE_DATE8

GLOBAL_ATTRIBUTE_DATE9

GLOBAL_ATTRIBUTE_NUMBER1

GLOBAL_ATTRIBUTE_NUMBER10

GLOBAL_ATTRIBUTE_NUMBER2

GLOBAL_ATTRIBUTE_NUMBER3

GLOBAL_ATTRIBUTE_NUMBER4

GLOBAL_ATTRIBUTE_NUMBER5

GLOBAL_ATTRIBUTE_NUMBER6

GLOBAL_ATTRIBUTE_NUMBER7

GLOBAL_ATTRIBUTE_NUMBER8

GLOBAL_ATTRIBUTE_NUMBER9

GLOBAL_ATTRIBUTE_TIMESTAMP1

GLOBAL_ATTRIBUTE_TIMESTAMP10

GLOBAL_ATTRIBUTE_TIMESTAMP2

GLOBAL_ATTRIBUTE_TIMESTAMP3

GLOBAL_ATTRIBUTE_TIMESTAMP4

GLOBAL_ATTRIBUTE_TIMESTAMP5

GLOBAL_ATTRIBUTE_TIMESTAMP6

GLOBAL_ATTRIBUTE_TIMESTAMP7

GLOBAL_ATTRIBUTE_TIMESTAMP8

GLOBAL_ATTRIBUTE_TIMESTAMP9

AGING_PERIOD_DAYS

AGING_ONSET_POINT

CONSUMPTION_ADVICE_FREQUENCY

CONSUMPTION_ADVICE_SUMMARY

PAY_ON_USE_FLAG

MODE_OF_TRANSPORT

SERVICE_LEVEL

ADDRESS_LINE1

ADDRESS_LINE2

ADDRESS_LINE3

ADDRESS_LINE4

ADDRESS_STYLE

ADDRESS_LINES_ALT

CITY

STATE

COUNTY

COUNTRY

ZIP

PROVINCE

LANGUAGE_CODE

DUNS_NUMBER

PARTY_SITE_NAME

BUILDING

FLOOR_NUMBER

ADDR_ELEMENT_ATTRIBUTE1

ADDR_ELEMENT_ATTRIBUTE2

ADDR_ELEMENT_ATTRIBUTE3

ADDR_ELEMENT_ATTRIBUTE4

ADDR_ELEMENT_ATTRIBUTE5

POSTAL_PLUS4_CODE

Query

SQL_Statement
SELECT PVS.VENDOR_SITE_SPK_ID, PVS.VENDOR_SITE_ID, PVS.EFFECTIVE_END_DATE, PVS.EFFECTIVE_START_DATE, PVS.EFFECTIVE_SEQUENCE, PVS.OBJECT_VERSION_NUMBER, PVS.INACTIVE_DATE, PVS.VENDOR_ID, PVS.PRC_BU_ID, PVS.LOCATION_ID, PVS.PARTY_SITE_ID, PVS.VENDOR_SITE_CODE, PVS.PURCHASING_SITE_FLAG, PVS.RFQ_ONLY_SITE_FLAG, PVS.PAY_SITE_FLAG, PVS.TP_HEADER_ID, PVS.SERVICES_TOLERANCE_ID, PVS.TOLERANCE_ID, PVS.TERMS_ID, PVS.EXCLUDE_FREIGHT_FROM_DISCOUNT, PVS.BANK_CHARGE_BEARER, PVS.PAY_ON_CODE, PVS.DEFAULT_PAY_SITE_ID, PVS.PAY_ON_RECEIPT_SUMMARY_CODE, PVS.ECE_TP_LOCATION_CODE, PVS.PCARD_SITE_FLAG, PVS.MATCH_OPTION, PVS.COUNTRY_OF_ORIGIN_CODE, PVS.CREATE_DEBIT_MEMO_FLAG, PVS.SUPPLIER_NOTIF_METHOD, PVS.EMAIL_ADDRESS, PVS.PRIMARY_PAY_SITE_FLAG, PVS.SHIPPING_CONTROL, PVS.SELLING_COMPANY_IDENTIFIER, PVS.GAPLESS_INV_NUM_FLAG, PVS.RETAINAGE_RATE, PVS.AUTO_CALCULATE_INTEREST_FLAG, PVS.HOLD_BY, PVS.HOLD_DATE, PVS.HOLD_FLAG, PVS.PURCHASING_HOLD_REASON, PVS.VENDOR_SITE_CODE_ALT, PVS.ATTENTION_AR_FLAG, PVS.AREA_CODE, PVS.PHONE, PVS.CUSTOMER_NUM, PVS.SHIP_VIA_LOOKUP_CODE, PVS.FREIGHT_TERMS_LOOKUP_CODE, PVS.FOB_LOOKUP_CODE, PVS.FAX, PVS.FAX_AREA_CODE, PVS.TELEX, PVS.TERMS_DATE_BASIS, PVS.PAY_GROUP_LOOKUP_CODE, PVS.PAYMENT_PRIORITY, PVS.INVOICE_AMOUNT_LIMIT, PVS.PAY_DATE_BASIS_LOOKUP_CODE, PVS.ALWAYS_TAKE_DISC_FLAG, PVS.INVOICE_CURRENCY_CODE, PVS.PAYMENT_CURRENCY_CODE, PVS.HOLD_ALL_PAYMENTS_FLAG, PVS.HOLD_FUTURE_PAYMENTS_FLAG, PVS.HOLD_REASON, PVS.HOLD_UNMATCHED_INVOICES_FLAG, PVS.PAYMENT_HOLD_DATE, PVS.TAX_REPORTING_SITE_FLAG, PVS.LAST_UPDATE_DATE, PVS.LAST_UPDATED_BY, PVS.LAST_UPDATE_LOGIN, PVS.CREATION_DATE, PVS.CREATED_BY, PVS.REQUEST_ID, PVS.PROGRAM_APPLICATION_ID, PVS.PROGRAM_ID, PVS.PROGRAM_UPDATE_DATE, PVS.ATTRIBUTE_CATEGORY, PVS.ATTRIBUTE1, PVS.ATTRIBUTE2, PVS.ATTRIBUTE3, PVS.ATTRIBUTE4, PVS.ATTRIBUTE5, PVS.ATTRIBUTE6, PVS.ATTRIBUTE7, PVS.ATTRIBUTE8, PVS.ATTRIBUTE9, PVS.ATTRIBUTE10, PVS.ATTRIBUTE11, PVS.ATTRIBUTE12, PVS.ATTRIBUTE13, PVS.ATTRIBUTE14, PVS.ATTRIBUTE15, PVS.GLOBAL_ATTRIBUTE1, PVS.GLOBAL_ATTRIBUTE2, PVS.GLOBAL_ATTRIBUTE3, PVS.GLOBAL_ATTRIBUTE4, PVS.GLOBAL_ATTRIBUTE5, PVS.GLOBAL_ATTRIBUTE6, PVS.GLOBAL_ATTRIBUTE7, PVS.GLOBAL_ATTRIBUTE8, PVS.GLOBAL_ATTRIBUTE9, PVS.GLOBAL_ATTRIBUTE10, PVS.GLOBAL_ATTRIBUTE11, PVS.GLOBAL_ATTRIBUTE12, PVS.GLOBAL_ATTRIBUTE13, PVS.GLOBAL_ATTRIBUTE14, PVS.GLOBAL_ATTRIBUTE15, PVS.GLOBAL_ATTRIBUTE16, PVS.GLOBAL_ATTRIBUTE17, PVS.GLOBAL_ATTRIBUTE18, PVS.GLOBAL_ATTRIBUTE19, PVS.GLOBAL_ATTRIBUTE20, PVS.GLOBAL_ATTRIBUTE_CATEGORY, PVS.CARRIER_ID, PVS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG, PVS.ALLOW_UNORDERED_RECEIPTS_FLAG, PVS.ENFORCE_SHIP_TO_LOCATION_CODE, PVS.QTY_RCV_EXCEPTION_CODE, PVS.RECEIPT_DAYS_EXCEPTION_CODE, PVS.INSPECTION_REQUIRED_FLAG, PVS.RECEIPT_REQUIRED_FLAG, PVS.QTY_RCV_TOLERANCE, PVS.DAYS_EARLY_RECEIPT_ALLOWED, PVS.DAYS_LATE_RECEIPT_ALLOWED, PVS.RECEIVING_ROUTING_ID, PVS.SHIPPING_NETWORK_LOCATION, PVS.PHONE_COUNTRY_CODE, PVS.PHONE_EXTENSION, PVS.FAX_COUNTRY_CODE, PVS.TAX_COUNTRY_CODE, PVS.ATTRIBUTE16, PVS.ATTRIBUTE17, PVS.ATTRIBUTE18, PVS.ATTRIBUTE19, PVS.ATTRIBUTE20, PVS.ATTRIBUTE_DATE1, PVS.ATTRIBUTE_DATE10, PVS.ATTRIBUTE_DATE2, PVS.ATTRIBUTE_DATE3, PVS.ATTRIBUTE_DATE4, PVS.ATTRIBUTE_DATE5, PVS.ATTRIBUTE_DATE6, PVS.ATTRIBUTE_DATE7, PVS.ATTRIBUTE_DATE8, PVS.ATTRIBUTE_DATE9, PVS.ATTRIBUTE_NUMBER1, PVS.ATTRIBUTE_NUMBER10, PVS.ATTRIBUTE_NUMBER2, PVS.ATTRIBUTE_NUMBER3, PVS.ATTRIBUTE_NUMBER4, PVS.ATTRIBUTE_NUMBER5, PVS.ATTRIBUTE_NUMBER6, PVS.ATTRIBUTE_NUMBER7, PVS.ATTRIBUTE_NUMBER8, PVS.ATTRIBUTE_NUMBER9, PVS.ATTRIBUTE_TIMESTAMP1, PVS.ATTRIBUTE_TIMESTAMP10, PVS.ATTRIBUTE_TIMESTAMP2, PVS.ATTRIBUTE_TIMESTAMP3, PVS.ATTRIBUTE_TIMESTAMP4, PVS.ATTRIBUTE_TIMESTAMP5, PVS.ATTRIBUTE_TIMESTAMP6, PVS.ATTRIBUTE_TIMESTAMP7, PVS.ATTRIBUTE_TIMESTAMP8, PVS.ATTRIBUTE_TIMESTAMP9, PVS.GLOBAL_ATTRIBUTE_DATE1, PVS.GLOBAL_ATTRIBUTE_DATE10, PVS.GLOBAL_ATTRIBUTE_DATE2, PVS.GLOBAL_ATTRIBUTE_DATE3, PVS.GLOBAL_ATTRIBUTE_DATE4, PVS.GLOBAL_ATTRIBUTE_DATE5, PVS.GLOBAL_ATTRIBUTE_DATE6, PVS.GLOBAL_ATTRIBUTE_DATE7, PVS.GLOBAL_ATTRIBUTE_DATE8, PVS.GLOBAL_ATTRIBUTE_DATE9, PVS.GLOBAL_ATTRIBUTE_NUMBER1, PVS.GLOBAL_ATTRIBUTE_NUMBER10, PVS.GLOBAL_ATTRIBUTE_NUMBER2, PVS.GLOBAL_ATTRIBUTE_NUMBER3, PVS.GLOBAL_ATTRIBUTE_NUMBER4, PVS.GLOBAL_ATTRIBUTE_NUMBER5, PVS.GLOBAL_ATTRIBUTE_NUMBER6, PVS.GLOBAL_ATTRIBUTE_NUMBER7, PVS.GLOBAL_ATTRIBUTE_NUMBER8, PVS.GLOBAL_ATTRIBUTE_NUMBER9, PVS.GLOBAL_ATTRIBUTE_TIMESTAMP1, PVS.GLOBAL_ATTRIBUTE_TIMESTAMP10, PVS.GLOBAL_ATTRIBUTE_TIMESTAMP2, PVS.GLOBAL_ATTRIBUTE_TIMESTAMP3, PVS.GLOBAL_ATTRIBUTE_TIMESTAMP4, PVS.GLOBAL_ATTRIBUTE_TIMESTAMP5, PVS.GLOBAL_ATTRIBUTE_TIMESTAMP6, PVS.GLOBAL_ATTRIBUTE_TIMESTAMP7, PVS.GLOBAL_ATTRIBUTE_TIMESTAMP8, PVS.GLOBAL_ATTRIBUTE_TIMESTAMP9, PVS.AGING_PERIOD_DAYS, PVS.AGING_ONSET_POINT, PVS.CONSUMPTION_ADVICE_FREQUENCY, PVS.CONSUMPTION_ADVICE_SUMMARY, PVS.PAY_ON_USE_FLAG, PVS.MODE_OF_TRANSPORT, PVS.SERVICE_LEVEL, hzl.address1 ADDRESS_LINE1, hzl.address2 ADDRESS_LINE2, hzl.address3 ADDRESS_LINE3, hzl.address4 ADDRESS_LINE4, hzl.address_style ADDRESS_STYLE, hzl.address_lines_phonetic ADDRESS_LINES_ALT, hzl.city CITY, hzl.state STATE, hzl.county COUNTY, hzl.country COUNTRY, hzl.postal_code ZIP, hzl.province PROVINCE, hzl.location_language LANGUAGE_CODE, hps.duns_number_c DUNS_NUMBER, hps.party_site_name PARTY_SITE_NAME, hzl.BUILDING, hzl.FLOOR_NUMBER, hzl.ADDR_ELEMENT_ATTRIBUTE1, hzl.ADDR_ELEMENT_ATTRIBUTE2, hzl.ADDR_ELEMENT_ATTRIBUTE3, hzl.ADDR_ELEMENT_ATTRIBUTE4, hzl.ADDR_ELEMENT_ATTRIBUTE5, hzl.POSTAL_PLUS4_CODE FROM POZ_SUPPLIER_SITES_ALL_M PVS, HZ_LOCATIONS hzl, HZ_PARTY_SITES hps WHERE hzl.location_id = pvs.location_id AND hps.party_site_id = pvs.party_site_id

SQL_Statement

SELECT PVS.VENDOR_SITE_SPK_ID,

PVS.VENDOR_SITE_ID,

PVS.EFFECTIVE_END_DATE,

PVS.EFFECTIVE_START_DATE,

PVS.EFFECTIVE_SEQUENCE,

PVS.OBJECT_VERSION_NUMBER,

PVS.INACTIVE_DATE,

PVS.VENDOR_ID,

PVS.PRC_BU_ID,

PVS.LOCATION_ID,

PVS.PARTY_SITE_ID,

PVS.VENDOR_SITE_CODE,

PVS.PURCHASING_SITE_FLAG,

PVS.RFQ_ONLY_SITE_FLAG,

PVS.PAY_SITE_FLAG,

PVS.TP_HEADER_ID,

PVS.SERVICES_TOLERANCE_ID,

PVS.TOLERANCE_ID,

PVS.TERMS_ID,

PVS.EXCLUDE_FREIGHT_FROM_DISCOUNT,

PVS.BANK_CHARGE_BEARER,

PVS.PAY_ON_CODE,

PVS.DEFAULT_PAY_SITE_ID,

PVS.PAY_ON_RECEIPT_SUMMARY_CODE,

PVS.ECE_TP_LOCATION_CODE,

PVS.PCARD_SITE_FLAG,

PVS.MATCH_OPTION,

PVS.COUNTRY_OF_ORIGIN_CODE,

PVS.CREATE_DEBIT_MEMO_FLAG,

PVS.SUPPLIER_NOTIF_METHOD,

PVS.EMAIL_ADDRESS,

PVS.PRIMARY_PAY_SITE_FLAG,

PVS.SHIPPING_CONTROL,

PVS.SELLING_COMPANY_IDENTIFIER,

PVS.GAPLESS_INV_NUM_FLAG,

PVS.RETAINAGE_RATE,

PVS.AUTO_CALCULATE_INTEREST_FLAG,

PVS.HOLD_BY,

PVS.HOLD_DATE,

PVS.HOLD_FLAG,

PVS.PURCHASING_HOLD_REASON,

PVS.VENDOR_SITE_CODE_ALT,

PVS.ATTENTION_AR_FLAG,

PVS.AREA_CODE,

PVS.PHONE,

PVS.CUSTOMER_NUM,

PVS.SHIP_VIA_LOOKUP_CODE,

PVS.FREIGHT_TERMS_LOOKUP_CODE,

PVS.FOB_LOOKUP_CODE,

PVS.FAX,

PVS.FAX_AREA_CODE,

PVS.TELEX,

PVS.TERMS_DATE_BASIS,

PVS.PAY_GROUP_LOOKUP_CODE,

PVS.PAYMENT_PRIORITY,

PVS.INVOICE_AMOUNT_LIMIT,

PVS.PAY_DATE_BASIS_LOOKUP_CODE,

PVS.ALWAYS_TAKE_DISC_FLAG,

PVS.INVOICE_CURRENCY_CODE,

PVS.PAYMENT_CURRENCY_CODE,

PVS.HOLD_ALL_PAYMENTS_FLAG,

PVS.HOLD_FUTURE_PAYMENTS_FLAG,

PVS.HOLD_REASON,

PVS.HOLD_UNMATCHED_INVOICES_FLAG,

PVS.PAYMENT_HOLD_DATE,

PVS.TAX_REPORTING_SITE_FLAG,

PVS.LAST_UPDATE_DATE,

PVS.LAST_UPDATED_BY,

PVS.LAST_UPDATE_LOGIN,

PVS.CREATION_DATE,

PVS.CREATED_BY,

PVS.REQUEST_ID,

PVS.PROGRAM_APPLICATION_ID,

PVS.PROGRAM_ID,

PVS.PROGRAM_UPDATE_DATE,

PVS.ATTRIBUTE_CATEGORY,

PVS.ATTRIBUTE1,

PVS.ATTRIBUTE2,

PVS.ATTRIBUTE3,

PVS.ATTRIBUTE4,

PVS.ATTRIBUTE5,

PVS.ATTRIBUTE6,

PVS.ATTRIBUTE7,

PVS.ATTRIBUTE8,

PVS.ATTRIBUTE9,

PVS.ATTRIBUTE10,

PVS.ATTRIBUTE11,

PVS.ATTRIBUTE12,

PVS.ATTRIBUTE13,

PVS.ATTRIBUTE14,

PVS.ATTRIBUTE15,

PVS.GLOBAL_ATTRIBUTE1,

PVS.GLOBAL_ATTRIBUTE2,

PVS.GLOBAL_ATTRIBUTE3,

PVS.GLOBAL_ATTRIBUTE4,

PVS.GLOBAL_ATTRIBUTE5,

PVS.GLOBAL_ATTRIBUTE6,

PVS.GLOBAL_ATTRIBUTE7,

PVS.GLOBAL_ATTRIBUTE8,

PVS.GLOBAL_ATTRIBUTE9,

PVS.GLOBAL_ATTRIBUTE10,

PVS.GLOBAL_ATTRIBUTE11,

PVS.GLOBAL_ATTRIBUTE12,

PVS.GLOBAL_ATTRIBUTE13,

PVS.GLOBAL_ATTRIBUTE14,

PVS.GLOBAL_ATTRIBUTE15,

PVS.GLOBAL_ATTRIBUTE16,

PVS.GLOBAL_ATTRIBUTE17,

PVS.GLOBAL_ATTRIBUTE18,

PVS.GLOBAL_ATTRIBUTE19,

PVS.GLOBAL_ATTRIBUTE20,

PVS.GLOBAL_ATTRIBUTE_CATEGORY,

PVS.CARRIER_ID,

PVS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,

PVS.ALLOW_UNORDERED_RECEIPTS_FLAG,

PVS.ENFORCE_SHIP_TO_LOCATION_CODE,

PVS.QTY_RCV_EXCEPTION_CODE,

PVS.RECEIPT_DAYS_EXCEPTION_CODE,

PVS.INSPECTION_REQUIRED_FLAG,

PVS.RECEIPT_REQUIRED_FLAG,

PVS.QTY_RCV_TOLERANCE,

PVS.DAYS_EARLY_RECEIPT_ALLOWED,

PVS.DAYS_LATE_RECEIPT_ALLOWED,

PVS.RECEIVING_ROUTING_ID,

PVS.SHIPPING_NETWORK_LOCATION,

PVS.PHONE_COUNTRY_CODE,

PVS.PHONE_EXTENSION,

PVS.FAX_COUNTRY_CODE,

PVS.TAX_COUNTRY_CODE,

PVS.ATTRIBUTE16,

PVS.ATTRIBUTE17,

PVS.ATTRIBUTE18,

PVS.ATTRIBUTE19,

PVS.ATTRIBUTE20,

PVS.ATTRIBUTE_DATE1,

PVS.ATTRIBUTE_DATE10,

PVS.ATTRIBUTE_DATE2,

PVS.ATTRIBUTE_DATE3,

PVS.ATTRIBUTE_DATE4,

PVS.ATTRIBUTE_DATE5,

PVS.ATTRIBUTE_DATE6,

PVS.ATTRIBUTE_DATE7,

PVS.ATTRIBUTE_DATE8,

PVS.ATTRIBUTE_DATE9,

PVS.ATTRIBUTE_NUMBER1,

PVS.ATTRIBUTE_NUMBER10,

PVS.ATTRIBUTE_NUMBER2,

PVS.ATTRIBUTE_NUMBER3,

PVS.ATTRIBUTE_NUMBER4,

PVS.ATTRIBUTE_NUMBER5,

PVS.ATTRIBUTE_NUMBER6,

PVS.ATTRIBUTE_NUMBER7,

PVS.ATTRIBUTE_NUMBER8,

PVS.ATTRIBUTE_NUMBER9,

PVS.ATTRIBUTE_TIMESTAMP1,

PVS.ATTRIBUTE_TIMESTAMP10,

PVS.ATTRIBUTE_TIMESTAMP2,

PVS.ATTRIBUTE_TIMESTAMP3,

PVS.ATTRIBUTE_TIMESTAMP4,

PVS.ATTRIBUTE_TIMESTAMP5,

PVS.ATTRIBUTE_TIMESTAMP6,

PVS.ATTRIBUTE_TIMESTAMP7,

PVS.ATTRIBUTE_TIMESTAMP8,

PVS.ATTRIBUTE_TIMESTAMP9,

PVS.GLOBAL_ATTRIBUTE_DATE1,

PVS.GLOBAL_ATTRIBUTE_DATE10,

PVS.GLOBAL_ATTRIBUTE_DATE2,

PVS.GLOBAL_ATTRIBUTE_DATE3,

PVS.GLOBAL_ATTRIBUTE_DATE4,

PVS.GLOBAL_ATTRIBUTE_DATE5,

PVS.GLOBAL_ATTRIBUTE_DATE6,

PVS.GLOBAL_ATTRIBUTE_DATE7,

PVS.GLOBAL_ATTRIBUTE_DATE8,

PVS.GLOBAL_ATTRIBUTE_DATE9,

PVS.GLOBAL_ATTRIBUTE_NUMBER1,

PVS.GLOBAL_ATTRIBUTE_NUMBER10,

PVS.GLOBAL_ATTRIBUTE_NUMBER2,

PVS.GLOBAL_ATTRIBUTE_NUMBER3,

PVS.GLOBAL_ATTRIBUTE_NUMBER4,

PVS.GLOBAL_ATTRIBUTE_NUMBER5,

PVS.GLOBAL_ATTRIBUTE_NUMBER6,

PVS.GLOBAL_ATTRIBUTE_NUMBER7,

PVS.GLOBAL_ATTRIBUTE_NUMBER8,

PVS.GLOBAL_ATTRIBUTE_NUMBER9,

PVS.GLOBAL_ATTRIBUTE_TIMESTAMP1,

PVS.GLOBAL_ATTRIBUTE_TIMESTAMP10,

PVS.GLOBAL_ATTRIBUTE_TIMESTAMP2,

PVS.GLOBAL_ATTRIBUTE_TIMESTAMP3,

PVS.GLOBAL_ATTRIBUTE_TIMESTAMP4,

PVS.GLOBAL_ATTRIBUTE_TIMESTAMP5,

PVS.GLOBAL_ATTRIBUTE_TIMESTAMP6,

PVS.GLOBAL_ATTRIBUTE_TIMESTAMP7,

PVS.GLOBAL_ATTRIBUTE_TIMESTAMP8,

PVS.GLOBAL_ATTRIBUTE_TIMESTAMP9,

PVS.AGING_PERIOD_DAYS,

PVS.AGING_ONSET_POINT,

PVS.CONSUMPTION_ADVICE_FREQUENCY,

PVS.CONSUMPTION_ADVICE_SUMMARY,

PVS.PAY_ON_USE_FLAG,

PVS.MODE_OF_TRANSPORT,

PVS.SERVICE_LEVEL,

hzl.address1 ADDRESS_LINE1,

hzl.address2 ADDRESS_LINE2,

hzl.address3 ADDRESS_LINE3,

hzl.address4 ADDRESS_LINE4,

hzl.address_style ADDRESS_STYLE,

hzl.address_lines_phonetic ADDRESS_LINES_ALT,

hzl.city CITY,

hzl.state STATE,

hzl.county COUNTY,

hzl.country COUNTRY,

hzl.postal_code ZIP,

hzl.province PROVINCE,

hzl.location_language LANGUAGE_CODE,

hps.duns_number_c DUNS_NUMBER,

hps.party_site_name PARTY_SITE_NAME,

hzl.BUILDING,

hzl.FLOOR_NUMBER,

hzl.ADDR_ELEMENT_ATTRIBUTE1,

hzl.ADDR_ELEMENT_ATTRIBUTE2,

hzl.ADDR_ELEMENT_ATTRIBUTE3,

hzl.ADDR_ELEMENT_ATTRIBUTE4,

hzl.ADDR_ELEMENT_ATTRIBUTE5,

hzl.POSTAL_PLUS4_CODE

FROM POZ_SUPPLIER_SITES_ALL_M PVS,

HZ_LOCATIONS hzl,

HZ_PARTY_SITES hps

WHERE hzl.location_id = pvs.location_id

AND hps.party_site_id = pvs.party_site_id