View: AP_VENDOR_SITES_V

Product:	AP - Payables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.AP_VENDOR_SITES_V

View Text

SELECT PVS.ROWID
, PVS.VENDOR_SITE_ID
, PVS.VENDOR_ID
, PVS.VENDOR_SITE_CODE
, PVS.LAST_UPDATE_DATE
, PVS.LAST_UPDATED_BY
, PVS.CREATED_BY
, PVS.CREATION_DATE
, PVS.LAST_UPDATE_LOGIN
, 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.SHIP_TO_LOCATION_ID
, HR_SHIPTO.LOCATION_CODE
, PVS.BILL_TO_LOCATION_ID
, HR_BILLTO.LOCATION_CODE
, PVS.SHIP_VIA_LOOKUP_CODE
, OGF.DESCRIPTION
, PVS.ADDRESS_LINE1
, PVS.ADDRESS_LINE2
, PVS.ADDRESS_LINE3
, PVS.ADDRESS_LINE4
, PVS.CITY
, PVS.COUNTY
, PVS.STATE
, PVS.ZIP
, PVS.COUNTRY
, PVS.PROVINCE
, FT.TERRITORY_SHORT_NAME
, AP_VENDOR_SITES_PKG.FORMAT_ADDRESS(PVS.COUNTRY
, PVS.ADDRESS_LINE1
, PVS.ADDRESS_LINE2
, PVS.ADDRESS_LINE3
, PVS.ADDRESS_LINE4
, PVS.CITY
, PVS.COUNTY
, PVS.STATE
, PVS.PROVINCE
, PVS.ZIP
, FT.TERRITORY_SHORT_NAME)
, PVS.AREA_CODE
, PVS.PHONE
, PVS.TELEX
, PVS.FAX_AREA_CODE
, PVS.FAX
, PVS.LANGUAGE
, FL.DESCRIPTION
, PVS.INACTIVE_DATE
, PVS.PURCHASING_SITE_FLAG
, PVS.PAY_SITE_FLAG
, PVS.RFQ_ONLY_SITE_FLAG
, PVS.FOB_LOOKUP_CODE
, LC_FOB.DISPLAYED_FIELD
, PVS.FREIGHT_TERMS_LOOKUP_CODE
, LC_TERMS.DISPLAYED_FIELD
, PVS.DISTRIBUTION_SET_ID
, AD.DISTRIBUTION_SET_NAME
, PVS.ACCTS_PAY_CODE_COMBINATION_ID
, PVS.PREPAY_CODE_COMBINATION_ID
, PVS.ALWAYS_TAKE_DISC_FLAG
, PVS.ATTENTION_AR_FLAG
, PVS.PAY_DATE_BASIS_LOOKUP_CODE
, PVS.PAY_GROUP_LOOKUP_CODE
, LC_GROUP.DISPLAYED_FIELD
, PVS.HOLD_FUTURE_PAYMENTS_FLAG
, PVS.HOLD_ALL_PAYMENTS_FLAG
, PVS.HOLD_REASON
, PVS.TERMS_DATE_BASIS
, PVS.TAX_REPORTING_SITE_FLAG
, PVS.TERMS_ID
, AT.NAME
, PVS.EXCLUDE_FREIGHT_FROM_DISCOUNT
, PVS.HOLD_UNMATCHED_INVOICES_FLAG
, PVS.INVOICE_AMOUNT_LIMIT
, PVS.CUSTOMER_NUM
, PVS.PAYMENT_CURRENCY_CODE
, PVS.PAYMENT_PRIORITY
, PVS.INVOICE_CURRENCY_CODE
, PVS.AWT_GROUP_ID
, AWT.NAME
, PVS.ALLOW_AWT_FLAG
, PVS.VALIDATION_NUMBER
, PVS.CHECK_DIGITS
, FT.ADDRESS_STYLE
, AT.END_DATE_ACTIVE
, AD.INACTIVE_DATE
, HR_SHIPTO.INACTIVE_DATE
, HR_BILLTO.INACTIVE_DATE
, LC_GROUP.INACTIVE_DATE
, LC_FOB.INACTIVE_DATE
, LC_TERMS.INACTIVE_DATE
, PVS.PAY_ON_CODE
, LC_ERS_PAY.DISPLAYED_FIELD
, PVS.DEFAULT_PAY_SITE_ID
, PVS2.VENDOR_SITE_CODE
, PVS.PAY_ON_RECEIPT_SUMMARY_CODE
, LC_ERS.DISPLAYED_FIELD
, PVS.VENDOR_SITE_CODE_ALT
, PVS.ADDRESS_LINES_ALT
, PVS.BANK_CHARGE_BEARER
, PVS.TP_HEADER_ID
, 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.ECE_TP_LOCATION_CODE
, PVS.PCARD_SITE_FLAG
, PVS.MATCH_OPTION
, PVS.FUTURE_DATED_PAYMENT_CCID FUTURE_DATED_PAYMENT_CCID
, PVS.CREATE_DEBIT_MEMO_FLAG
, PVS.COUNTRY_OF_ORIGIN_CODE
, FT2.TERRITORY_SHORT_NAME COUNTRY_OF_ORIGIN_SHORT_NAME
, PLA.LOCATION_ID SHIPPING_LOCATION_ID
, PVS.SUPPLIER_NOTIF_METHOD
, PVS.EMAIL_ADDRESS
, PVS.PRIMARY_PAY_SITE_FLAG
, PVS.ORG_ID
FROM PO_VENDOR_SITES PVS
, PO_VENDOR_SITES_ALL PVS2
, PO_LOOKUP_CODES LC_TERMS
, PO_LOOKUP_CODES LC_FOB
, PO_LOOKUP_CODES LC_GROUP
, AP_DISTRIBUTION_SETS_ALL AD
, HR_LOCATIONS_ALL HR_SHIPTO
, HR_LOCATIONS_ALL HR_BILLTO
, ORG_FREIGHT OGF
, FND_TERRITORIES_VL FT
, FND_TERRITORIES_VL FT2
, FND_LANGUAGES_VL FL
, AP_TERMS AT
, AP_AWT_GROUPS AWT
, FINANCIALS_SYSTEM_PARAMS_ALL FIN
, PO_LOOKUP_CODES LC_ERS_PAY
, PO_LOOKUP_CODES LC_ERS
, PO_LOCATION_ASSOCIATIONS_ALL PLA
WHERE LC_TERMS.LOOKUP_CODE(+) = PVS.FREIGHT_TERMS_LOOKUP_CODE
AND NVL(PVS.ORG_ID
, -99) = NVL(FIN.ORG_ID
, -99)
AND LC_TERMS.LOOKUP_TYPE(+) = 'FREIGHT TERMS'
AND LC_FOB.LOOKUP_CODE(+) = PVS.FOB_LOOKUP_CODE
AND LC_FOB.LOOKUP_TYPE(+) = 'FOB'
AND LC_GROUP.LOOKUP_CODE(+) = PVS.PAY_GROUP_LOOKUP_CODE
AND LC_GROUP.LOOKUP_TYPE(+) = 'PAY GROUP'
AND AT.TERM_ID(+) = PVS.TERMS_ID
AND FT.TERRITORY_CODE(+) = PVS.COUNTRY
AND FT2.TERRITORY_CODE(+) = PVS.COUNTRY_OF_ORIGIN_CODE
AND FL.NLS_LANGUAGE(+) = PVS.LANGUAGE
AND AD.DISTRIBUTION_SET_ID(+) = PVS.DISTRIBUTION_SET_ID
AND HR_SHIPTO.LOCATION_ID(+) = PVS.SHIP_TO_LOCATION_ID
AND HR_BILLTO.LOCATION_ID(+) = PVS.BILL_TO_LOCATION_ID
AND AWT.GROUP_ID(+) = PVS.AWT_GROUP_ID
AND OGF.ORGANIZATION_ID (+) = AP_UTILITIES_PKG.GET_INVENTORY_ORG(PVS.ORG_ID)
AND OGF.FREIGHT_CODE(+) = PVS.SHIP_VIA_LOOKUP_CODE
AND LC_ERS_PAY.LOOKUP_CODE(+)=PVS.PAY_ON_CODE
AND LC_ERS_PAY.LOOKUP_TYPE(+)='ERS PAY_ON_CODE'
AND LC_ERS.LOOKUP_CODE(+)=PVS.PAY_ON_RECEIPT_SUMMARY_CODE
AND LC_ERS.LOOKUP_TYPE(+)='ERS INVOICE_SUMMARY'
AND PVS2.VENDOR_SITE_ID(+)=PVS.DEFAULT_PAY_SITE_ID
AND PVS.VENDOR_SITE_ID = PLA.VENDOR_SITE_ID(+)

Columns