View: ITG_REQ_VENDOR_SITES_V

Product:	ITG - Internet Procurement Enterprise Connector
Description:	This view is used to generate XML segment containing requistion supplier location information
Implementation/DBA Data:	APPS.ITG_REQ_VENDOR_SITES_V

View Text

SELECT LA.REQUISITION_LINE_ID
, VS.VENDOR_ID
, VS.VENDOR_SITE_ID
, VS.ADDRESS_LINE1 SUPPLIER_ADDR_LINE1
, VS.ADDRESS_LINE2 SUPPLIER_ADDR_LINE2
, VS.ADDRESS_LINE3 SUPPLIER_ADDR_LINE3
, VS.CITY SUPPLIER_ADDR_CITY
, VS.COUNTRY SUPPLIER_ADDR_COUNTRY
, VS.COUNTY SUPPLIER_ADDR_COUNTY
, VS.VENDOR_SITE_CODE SUPPLIER_ADDR_DESCRIPTN
, DECODE(VS.FAX_AREA_CODE
, NULL
, NULL
, VS.FAX_AREA_CODE||' ')SUPPLIER_ADDR_FAX
, VS.ZIP SUPPLIER_ADDR_POSTALCODE
, NVL(VS.STATE
, VS.PROVINCE) SUPPLIER_ADDR_STATEPROVN
, NULL SUPPLIER_ADDR_UA_VATCODE
, VS.PURCHASING_SITE_FLAG SUPPLIER_ADDR_UA_PURSITE
, VS.PAY_SITE_FLAG SUPPLIER_ADDR_UA_PAYSITE
, VS.RFQ_ONLY_SITE_FLAG SUPPLIER_ADDR_UA_RFQSITE
, VS.PCARD_SITE_FLAG SUPPLIER_ADDR_UA_PCSITE
FROM PO_VENDOR_SITES_ALL VS
, PO_REQUISITION_LINES_ALL LA
WHERE VS.VENDOR_SITE_CODE (+) = LA.SUGGESTED_VENDOR_LOCATION
AND VS.ORG_ID = LA.ORG_ID

Columns