View: JTF_RS_SUPPLIERS_VL

Product:	JTF - CRM Foundation
Description:	The details of supplier contacts that can be imported as resource or are already present as resource
Implementation/DBA Data:	APPS.JTF_RS_SUPPLIERS_VL

View Text

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

Columns