View: ICX_PO_VENDOR_SITES_V

View Text

SELECT "VENDOR_SITE_ID"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "VENDOR_ID"
, "VENDOR_SITE_CODE"
, "LAST_UPDATE_LOGIN"
, "CREATION_DATE"
, "CREATED_BY"
, "PURCHASING_SITE_FLAG"
, "RFQ_ONLY_SITE_FLAG"
, "PAY_SITE_FLAG"
, "ATTENTION_AR_FLAG"
, "ADDRESS_LINE1"
, "ADDRESS_LINE2"
, "ADDRESS_LINE3"
, "CITY"
, "STATE"
, "ZIP"
, "PROVINCE"
, "COUNTRY"
, "AREA_CODE"
, "PHONE"
, "CUSTOMER_NUM"
, "SHIP_TO_LOCATION_ID"
, "BILL_TO_LOCATION_ID"
, "SHIP_VIA_LOOKUP_CODE"
, "FREIGHT_TERMS_LOOKUP_CODE"
, "FOB_LOOKUP_CODE"
, "INACTIVE_DATE"
, "FAX"
, "FAX_AREA_CODE"
, "TELEX"
, "PAYMENT_METHOD_LOOKUP_CODE"
, "BANK_ACCOUNT_NAME"
, "BANK_ACCOUNT_NUM"
, "BANK_NUM"
, "BANK_ACCOUNT_TYPE"
, "TERMS_DATE_BASIS"
, "CURRENT_CATALOG_NUM"
, "VAT_CODE"
, "DISTRIBUTION_SET_ID"
, "ACCTS_PAY_CODE_COMBINATION_ID"
, "PREPAY_CODE_COMBINATION_ID"
, "PAY_GROUP_LOOKUP_CODE"
, "PAYMENT_PRIORITY"
, "TERMS_ID"
, "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"
, "EXCLUSIVE_PAYMENT_FLAG"
, "TAX_REPORTING_SITE_FLAG"
, "ATTRIBUTE_CATEGORY"
, "ATTRIBUTE1"
, "ATTRIBUTE2"
, "ATTRIBUTE3"
, "ATTRIBUTE4"
, "ATTRIBUTE5"
, "ATTRIBUTE6"
, "ATTRIBUTE7"
, "ATTRIBUTE8"
, "ATTRIBUTE9"
, "ATTRIBUTE10"
, "ATTRIBUTE11"
, "ATTRIBUTE12"
, "ATTRIBUTE13"
, "ATTRIBUTE14"
, "ATTRIBUTE15"
, "REQUEST_ID"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "PROGRAM_UPDATE_DATE"
, "VALIDATION_NUMBER"
, "EXCLUDE_FREIGHT_FROM_DISCOUNT"
, "VAT_REGISTRATION_NUM"
, "OFFSET_VAT_CODE"
, "ORG_ID"
, "CHECK_DIGITS"
, "BANK_NUMBER"
, "ADDRESS_LINE4"
, "COUNTY"
, "ADDRESS_STYLE"
, "LANGUAGE"
, "ALLOW_AWT_FLAG"
, "AWT_GROUP_ID"
FROM PO_VENDOR_SITES

Columns