VIEW: APPS.AP_VENDOR_SITES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)