View: OKX_VENDOR_CONTACTS_V

Product:	OKX - Contracts Integration
Description:	Supplier contacts
Implementation/DBA Data:	APPS.OKX_VENDOR_CONTACTS_V

View Text

SELECT VC.VENDOR_CONTACT_ID ID1
, '#' ID2
, VC.VENDOR_SITE_ID VENDOR_SITE_ID
, LAST_NAME || ' ' || FIRST_NAME NAME
, VC.INACTIVE_DATE - 1 END_DATE_ACTIVE
, DECODE(SYSDATE - NVL(VC.INACTIVE_DATE
, SYSDATE)
, 0
, SYSDATE
, DECODE(SYSDATE - NVL(VC.INACTIVE_DATE
, SYSDATE) + ABS(SYSDATE - NVL(VC.INACTIVE_DATE
, SYSDATE))
, 0
, SYSDATE
, VC.INACTIVE_DATE )) START_DATE_ACTIVE
, DECODE(SIGN(NVL(VC.INACTIVE_DATE
, SYSDATE) - SYSDATE)
, -1
, 'I'
, 'A') STATUS
, VC.TITLE || ' ' || VC.PHONE DESCRIPTION
, VC.PHONE PHONE
, VS.VENDOR_ID PARTY_ID
, '#' PARTY_ID2
, VS.ORG_ID ORG_ID
, VS.EMAIL_ADDRESS
FROM PO_VENDOR_CONTACTS VC
, PO_VENDOR_SITES_ALL VS
WHERE VS.VENDOR_SITE_ID = VC.VENDOR_SITE_ID

Columns