View: ITG_REQ_VENDOR_CONTACTS_V

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

View Text

SELECT LA.REQUISITION_LINE_ID
, VC.VENDOR_SITE_ID
, DECODE(VC.AREA_CODE
, NULL
, NULL
, VC.AREA_CODE||' ') SUPPLIER_ADDR_TELEPHONE1
, DECODE(VC.FIRST_NAME
, NULL
, NULL
, VC.FIRST_NAME||' ')|| DECODE(VC.MIDDLE_NAME
, NULL
, NULL
, VC.MIDDLE_NAME||' ')|| VC.LAST_NAME SUPPLIER_CONTACT_NAME1
, VC.TITLE SUPPLIER_CONTACT_DESCRIPTN
, DECODE(VC.AREA_CODE
, NULL
, NULL
, VC.AREA_CODE||' ') SUPPLIER_CONTACT_TELEPHONE1
FROM PO_VENDOR_CONTACTS VC
, PO_REQUISITION_LINES_ALL LA
WHERE UPPER(LA.SUGGESTED_VENDOR_CONTACT) LIKE UPPER(VC.LAST_NAME)||'
, '||UPPER(VC.FIRST_NAME)

Columns