VIEW: APPS.JTF_RS_SUPPLIERS_VL

Source

View Text - Preformatted

SELECT v.vendor_id SUPPLIER_ID ,v.segment1 SUPPLIER_NUMBER ,v.vendor_name SUPPLIER_NAME ,s.vendor_site_id SUPPLIER_SITE_ID ,s.vendor_site_code SUPPLIER_SITE_CODE ,s.org_id ORG_ID ,s.address_line1 ADDRESS_LINE1 ,s.address_line2 ADDRESS_LINE2 ,s.address_line3 ADDRESS_LINE3 ,s.city CITY ,s.zip ZIP_CODE ,s.state STATE ,s.province PROVINCE ,s.county COUNTY ,s.country COUNTRY ,c.vendor_contact_id SUPPLIER_CONTACT_ID ,c.first_name FIRST_NAME ,c.last_name LAST_NAME ,c.area_code AREA_CODE ,c.phone PHONE ,null EMAIL ,null FAX ,org.name ORG_NAME from po_vendors v ,po_vendor_sites_all s ,po_vendor_contacts c ,HR_OPERATING_UNITS org WHERE s.vendor_id = v.vendor_id and s.vendor_site_id = c.vendor_site_id and org.organization_id = s.org_id

View Text - HTML Formatted

SELECT V.VENDOR_ID SUPPLIER_ID
, V.SEGMENT1 SUPPLIER_NUMBER
, V.VENDOR_NAME SUPPLIER_NAME
, S.VENDOR_SITE_ID SUPPLIER_SITE_ID
, S.VENDOR_SITE_CODE SUPPLIER_SITE_CODE
, S.ORG_ID ORG_ID
, S.ADDRESS_LINE1 ADDRESS_LINE1
, S.ADDRESS_LINE2 ADDRESS_LINE2
, S.ADDRESS_LINE3 ADDRESS_LINE3
, S.CITY CITY
, S.ZIP ZIP_CODE
, S.STATE STATE
, S.PROVINCE PROVINCE
, S.COUNTY COUNTY
, S.COUNTRY COUNTRY
, C.VENDOR_CONTACT_ID SUPPLIER_CONTACT_ID
, C.FIRST_NAME FIRST_NAME
, C.LAST_NAME LAST_NAME
, C.AREA_CODE AREA_CODE
, C.PHONE PHONE
, NULL EMAIL
, NULL FAX
, ORG.NAME ORG_NAME
FROM PO_VENDORS V
, PO_VENDOR_SITES_ALL S
, PO_VENDOR_CONTACTS C
, HR_OPERATING_UNITS ORG
WHERE S.VENDOR_ID = V.VENDOR_ID
AND S.VENDOR_SITE_ID = C.VENDOR_SITE_ID
AND ORG.ORGANIZATION_ID = S.ORG_ID