eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AP_VENDOR_DISP_V

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

View Text

SELECT PVS.ROWID
, PVS.VENDOR_ID
, PV.VENDOR_NAME
, PV.SEGMENT1
, PVS.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, 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.INVOICE_CURRENCY_CODE
, PVS.ADDRESS_STYLE
FROM PO_VENDOR_SITES PVS
, PO_VENDORS PV
, FND_TERRITORIES_VL FT
, FND_LANGUAGES_VL FL
WHERE PV.VENDOR_ID = PVS.VENDOR_ID
AND FT.TERRITORY_CODE(+) = PVS.COUNTRY
AND FL.NLS_LANGUAGE(+) = PVS.LANGUAGE

Columns

Name
ROW_ID
VENDOR_ID
VENDOR_NAME
VENDOR_NUMBER
VENDOR_SITE_ID
VENDOR_SITE_CODE
ADDRESS_LINE1
ADDRESS_LINE2
ADDRESS_LINE3
ADDRESS_LINE4
CITY
COUNTY
STATE
ZIP
COUNTRY
PROVINCE
TERRITORY_SHORT_NAME
CONCATENATED_ADDRESS
AREA_CODE
PHONE
TELEX
FAX_AREA_CODE
FAX
LANGUAGE
LANGUAGE_DESCRIPTION
INVOICE_CURRENCY_CODE
ADDRESS_STYLE