[Home] [Help]
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
Name |
REQUISITION_LINE_ID |
VENDOR_SITE_ID |
SUPPLIER_ADDR_TELEPHONE1 |
SUPPLIER_CONTACT_NAME1 |
SUPPLIER_CONTACT_DESCRIPTN |
SUPPLIER_CONTACT_TELEPHONE1 |