POZ_SUPPLIER_SITES_ALL_X
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 INACTIVE_DATE OBJECT_VERSION_NUMBER 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 AGING_PERIOD_DAYS AGING_ONSET_POINT CONSUMPTION_ADVICE_FREQUENCY CONSUMPTION_ADVICE_SUMMARY PAY_ON_USE_FLAG MODE_OF_TRANSPORT SERVICE_LEVEL |
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.INACTIVE_DATE, PVS.OBJECT_VERSION_NUMBER, 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.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 FROM POZ_SUPPLIER_SITES_ALL_M PVS |