[Home] [Help]
View: 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
Name |
ID1 |
ID2 |
VENDOR_SITE_ID |
NAME |
END_DATE_ACTIVE |
START_DATE_ACTIVE |
STATUS |
DESCRIPTION |
PHONE |
PARTY_ID |
PARTY_ID2 |
ORG_ID |
EMAIL_ADDRESS |