VIEW: APPS.ITG_REQ_VENDOR_SITES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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