View: POBV_SUPPLIER_SITES

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POBV_SUPPLIER_SITES

View Text

SELECT VS.VENDOR_SITE_ID
, VS.VENDOR_SITE_CODE
, VS.VENDOR_ID
, VE.VENDOR_NAME
, VS.ORG_ID
, OP.NAME
, VS.VENDOR_SITE_CODE_ALT
, VS.COUNTRY
, VS.ADDRESS_LINE1
, VS.ADDRESS_LINE2
, VS.ADDRESS_LINE3
, VS.ADDRESS_LINE4
, VS.CITY
, VS.STATE
, VS.ZIP
, VS.PROVINCE
, VS.COUNTY
, VS.ADDRESS_LINES_ALT
, VS.LANGUAGE
, VS.INACTIVE_DATE
, '_LA:VS.PAY_SITE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.PURCHASING_SITE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.RFQ_ONLY_SITE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VS.AREA_CODE
, VS.PHONE
, VS.TELEX
, VS.FAX_AREA_CODE
, VS.FAX
, VS.VAT_CODE
, VS.OFFSET_VAT_CODE
, VS.AUTO_TAX_CALC_FLAG
, '_LA:VS.AUTO_TAX_CALC_OVERRIDE:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VS.AP_TAX_ROUNDING_RULE
, '_LA:VS.AMOUNT_INCLUDES_TAX_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VS.VAT_REGISTRATION_NUM
, '_LA:VS.TAX_REPORTING_SITE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VS.INVOICE_AMOUNT_LIMIT
, '_LA:VS.HOLD_ALL_PAYMENTS_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.HOLD_FUTURE_PAYMENTS_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.HOLD_UNMATCHED_INVOICES_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VS.HOLD_REASON
, '_LA:VS.PAY_GROUP_LOOKUP_CODE:PO_LOOKUP_CODES:PAY GROUP:DISPLAYED_FIELD'
, VS.PAYMENT_PRIORITY
, '_LA:VS.TERMS_DATE_BASIS:AP_LOOKUP_CODES:TERMS DATE BASIS:DISPLAYED_FIELD'
, '_LA:VS.PAY_DATE_BASIS_LOOKUP_CODE:PO_LOOKUP_CODES:PAY DATE BASIS:DISPLAYED_FIELD'
, '_LA:VS.PAYMENT_METHOD_LOOKUP_CODE:AP_LOOKUP_CODES:PAYMENT METHOD:DISPLAYED_FIELD'
, '_LA:VS.ALWAYS_TAKE_DISC_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.EXCLUDE_FREIGHT_FROM_DISCOUNT:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.EXCLUSIVE_PAYMENT_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.ATTENTION_AR_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.FREIGHT_TERMS_LOOKUP_CODE:PO_LOOKUP_CODES:FREIGHT TERMS:DISPLAYED_FIELD'
, '_LA:VS.FOB_LOOKUP_CODE:AR_LOOKUPS:FOB:MEANING'
, '_LA:VS.PAY_ON_CODE:PO_LOOKUP_CODES:ERS PAY_ON_CODE:DISPLAYED_FIELD'
, '_LA:VS.PAY_ON_RECEIPT_SUMMARY_CODE:PO_LOOKUP_CODES:ERS INVOICE_SUMMARY:DISPLAYED_FIELD'
, '_LA:VS.ALLOW_AWT_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VS.EDI_ID_NUMBER
, VS.EDI_PAYMENT_METHOD
, VS.EDI_PAYMENT_FORMAT
, VS.EDI_REMITTANCE_METHOD
, VS.EDI_REMITTANCE_INSTRUCTION
, VS.EDI_TRANSACTION_HANDLING
, VS.ACCTS_PAY_CODE_COMBINATION_ID
, VS.PREPAY_CODE_COMBINATION_ID
, VS.INVOICE_CURRENCY_CODE
, VS.PAYMENT_CURRENCY_CODE
, VS.TERMS_ID
, VS.SHIP_TO_LOCATION_ID
, VS.BILL_TO_LOCATION_ID
, VS.SHIP_VIA_LOOKUP_CODE
, VS.DEFAULT_PAY_SITE_ID
, VS.CREATION_DATE
, VS.CREATED_BY
, VS.LAST_UPDATE_DATE
, VS.LAST_UPDATED_BY
, VS.BANK_BRANCH_TYPE
, VS.MATCH_OPTION
, VS.FUTURE_DATED_PAYMENT_CCID
, '_LA:VS.CREATE_DEBIT_MEMO_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.OFFSET_TAX_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VS.SUPPLIER_NOTIF_METHOD
, VS.EMAIL_ADDRESS
, VS.REMITTANCE_EMAIL
, '_LA:VS.PRIMARY_PAY_SITE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.PCARD_SITE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VS.COUNTRY_OF_ORIGIN_CODE
FROM PO_VENDOR_SITES_ALL VS
, PO_VENDORS VE
, HR_ALL_ORGANIZATION_UNITS OP
WHERE VS.VENDOR_ID = VE.VENDOR_ID
AND VS.ORG_ID = OP.ORGANIZATION_ID
AND '_SEC:VS.ORG_ID' IS NOT NULL WITH READ ONLY

Columns