[Home] [Help]
View: PO_VENDOR_SITES_ALL
View Text
SELECT
PVS.ADDRESS_STYLE ADDRESS_STYLE
, PVS.LANGUAGE LANGUAGE
, PVS.PROVINCE PROVINCE
, PVS.COUNTRY COUNTRY
, PVS.AREA_CODE AREA_CODE
, PVS.PHONE PHONE
, PVS.CUSTOMER_NUM CUSTOMER_NUM
, PVS.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, PVS.BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, PVS.SHIP_VIA_LOOKUP_CODE SHIP_VIA_LOOKUP_CODE
, PVS.FREIGHT_TERMS_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE
, PVS.FOB_LOOKUP_CODE FOB_LOOKUP_CODE
, PVS.INACTIVE_DATE INACTIVE_DATE
, PVS.FAX FAX
, PVS.FAX_AREA_CODE FAX_AREA_CODE
, PVS.TELEX TELEX
, PVS.TERMS_DATE_BASIS TERMS_DATE_BASIS
, PVS.DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, PVS.ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID
, PVS.PREPAY_CODE_COMBINATION_ID PREPAY_CODE_COMBINATION_ID
, PVS.PAY_GROUP_LOOKUP_CODE PAY_GROUP_LOOKUP_CODE
, PVS.PAYMENT_PRIORITY PAYMENT_PRIORITY
, PVS.TERMS_ID TERMS_ID
, PVS.INVOICE_AMOUNT_LIMIT INVOICE_AMOUNT_LIMIT
, PVS.PAY_DATE_BASIS_LOOKUP_CODE PAY_DATE_BASIS_LOOKUP_CODE
, PVS.ALWAYS_TAKE_DISC_FLAG ALWAYS_TAKE_DISC_FLAG
, PVS.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, PVS.PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, PVS.COUNTY COUNTY
, PVS.VENDOR_SITE_ID VENDOR_SITE_ID
, PVS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PVS.LAST_UPDATED_BY LAST_UPDATED_BY
, PVS.VENDOR_ID VENDOR_ID
, PVS.VENDOR_SITE_CODE VENDOR_SITE_CODE
, PVS.VENDOR_SITE_CODE_ALT VENDOR_SITE_CODE_ALT
, PVS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PVS.CREATION_DATE CREATION_DATE
, PVS.CREATED_BY CREATED_BY
, PVS.PURCHASING_SITE_FLAG PURCHASING_SITE_FLAG
, PVS.RFQ_ONLY_SITE_FLAG RFQ_ONLY_SITE_FLAG
, PVS.PAY_SITE_FLAG PAY_SITE_FLAG
, PVS.ATTENTION_AR_FLAG ATTENTION_AR_FLAG
, PVS.ADDRESS_LINE1 ADDRESS_LINE1
, PVS.ADDRESS_LINE2 ADDRESS_LINE2
, PVS.ADDRESS_LINE3 ADDRESS_LINE3
, PVS.ADDRESS_LINES_ALT ADDRESS_LINES_ALT
, PVS.CITY CITY
, PVS.STATE STATE
, PVS.ZIP ZIP
, PVS.HOLD_ALL_PAYMENTS_FLAG HOLD_ALL_PAYMENTS_FLAG
, PVS.HOLD_FUTURE_PAYMENTS_FLAG HOLD_FUTURE_PAYMENTS_FLAG
, PVS.HOLD_REASON HOLD_REASON
, PVS.HOLD_UNMATCHED_INVOICES_FLAG HOLD_UNMATCHED_INVOICES_FLAG
, PVS.TAX_REPORTING_SITE_FLAG TAX_REPORTING_SITE_FLAG
, PVS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PVS.ATTRIBUTE1 ATTRIBUTE1
, PVS.ATTRIBUTE2 ATTRIBUTE2
, PVS.ATTRIBUTE3 ATTRIBUTE3
, PVS.ATTRIBUTE4 ATTRIBUTE4
, PVS.ATTRIBUTE5 ATTRIBUTE5
, PVS.ATTRIBUTE6 ATTRIBUTE6
, PVS.ATTRIBUTE7 ATTRIBUTE7
, PVS.ATTRIBUTE8 ATTRIBUTE8
, PVS.ATTRIBUTE9 ATTRIBUTE9
, PVS.ATTRIBUTE10 ATTRIBUTE10
, PVS.ATTRIBUTE11 ATTRIBUTE11
, PVS.ATTRIBUTE12 ATTRIBUTE12
, PVS.ATTRIBUTE13 ATTRIBUTE13
, PVS.ATTRIBUTE14 ATTRIBUTE14
, PVS.ATTRIBUTE15 ATTRIBUTE15
, PVS.REQUEST_ID REQUEST_ID
, PVS.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PVS.PROGRAM_ID PROGRAM_ID
, PVS.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PVS.VALIDATION_NUMBER VALIDATION_NUMBER
, PVS.EXCLUDE_FREIGHT_FROM_DISCOUNT EXCLUDE_FREIGHT_FROM_DISCOUNT
, PVS.BANK_CHARGE_BEARER BANK_CHARGE_BEARER
, PVS.ORG_ID ORG_ID
, PVS.CHECK_DIGITS CHECK_DIGITS
, PVS.ADDRESS_LINE4 ADDRESS_LINE4
, PVS.ALLOW_AWT_FLAG ALLOW_AWT_FLAG
, PVS.AWT_GROUP_ID AWT_GROUP_ID
, PVS.DEFAULT_PAY_SITE_ID DEFAULT_PAY_SITE_ID
, PVS.PAY_ON_CODE PAY_ON_CODE
, PVS.PAY_ON_RECEIPT_SUMMARY_CODE PAY_ON_RECEIPT_SUMMARY_CODE
, PVS.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, PVS.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, PVS.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, PVS.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, PVS.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, PVS.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, PVS.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, PVS.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, PVS.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, PVS.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, PVS.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, PVS.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, PVS.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, PVS.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, PVS.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, PVS.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, PVS.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, PVS.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, PVS.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, PVS.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, PVS.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, PVS.TP_HEADER_ID TP_HEADER_ID
, PVS.ECE_TP_LOCATION_CODE ECE_TP_LOCATION_CODE
, PVS.PCARD_SITE_FLAG PCARD_SITE_FLAG
, PVS.MATCH_OPTION MATCH_OPTION
, PVS.COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE
, PVS.FUTURE_DATED_PAYMENT_CCID FUTURE_DATED_PAYMENT_CCID
, PVS.CREATE_DEBIT_MEMO_FLAG CREATE_DEBIT_MEMO_FLAG
, PVS.SUPPLIER_NOTIF_METHOD SUPPLIER_NOTIF_METHOD
, PVS.EMAIL_ADDRESS EMAIL_ADDRESS
, PVS.PRIMARY_PAY_SITE_FLAG PRIMARY_PAY_SITE_FLAG
, PVS.SHIPPING_CONTROL SHIPPING_CONTROL
, PVS.SELLING_COMPANY_IDENTIFIER SELLING_COMPANY_IDENTIFIER
, PVS.GAPLESS_INV_NUM_FLAG GAPLESS_INV_NUM_FLAG
, PVS.DUNS_NUMBER DUNS_NUMBER
, PVS.LOCATION_ID LOCATION_ID
, PVS.PARTY_SITE_ID PARTY_SITE_ID
, PVS.TOLERANCE_ID TOLERANCE_ID
, PVS.SERVICES_TOLERANCE_ID SERVICES_TOLERANCE_ID
, PVS.PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD_LOOKUP_CODE
, PVS.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, PVS.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, PVS.BANK_NUM BANK_NUM
, PVS.BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE
, PVS.CURRENT_CATALOG_NUM CURRENT_CATALOG_NUM
, PVS.VAT_CODE VAT_CODE
, PVS.AP_TAX_ROUNDING_RULE AP_TAX_ROUNDING_RULE
, PVS.AUTO_TAX_CALC_FLAG AUTO_TAX_CALC_FLAG
, PVS.AUTO_TAX_CALC_OVERRIDE AUTO_TAX_CALC_OVERRIDE
, PVS.AMOUNT_INCLUDES_TAX_FLAG AMOUNT_INCLUDES_TAX_FLAG
, PVS.OFFSET_VAT_CODE OFFSET_VAT_CODE
, PVS.BANK_NUMBER BANK_NUMBER
, PVS.BANK_BRANCH_TYPE BANK_BRANCH_TYPE
, PVS.OFFSET_TAX_FLAG OFFSET_TAX_FLAG
, PVS.REMITTANCE_EMAIL REMITTANCE_EMAIL
, PVS.EDI_TRANSACTION_HANDLING EDI_TRANSACTION_HANDLING
, PVS.EDI_ID_NUMBER EDI_ID_NUMBER
, PVS.EDI_PAYMENT_METHOD EDI_PAYMENT_METHOD
, PVS.EDI_PAYMENT_FORMAT EDI_PAYMENT_FORMAT
, PVS.EDI_REMITTANCE_METHOD EDI_REMITTANCE_METHOD
, PVS.EDI_REMITTANCE_INSTRUCTION EDI_REMITTANCE_INSTRUCTION
, PVS.EXCLUSIVE_PAYMENT_FLAG EXCLUSIVE_PAYMENT_FLAG
, PVS.VAT_REGISTRATION_NUM VAT_REGISTRATION_NUM
, PVS.RETAINAGE_RATE RETAINAGE_RATE
, PVS.TCA_SYNC_STATE TCA_SYNC_STATE
, PVS.TCA_SYNC_PROVINCE TCA_SYNC_PROVINCE
, PVS.TCA_SYNC_COUNTY TCA_SYNC_COUNTY
, PVS.TCA_SYNC_CITY TCA_SYNC_CITY
, PVS.TCA_SYNC_ZIP TCA_SYNC_ZIP
, PVS.TCA_SYNC_COUNTRY TCA_SYNC_COUNTRY
, PVS.PAY_AWT_GROUP_ID PAY_AWT_GROUP_ID
FROM
AP_SUPPLIER_SITES_ALL PVS
APPS.PO_VENDOR_SITES_ALL