View: PO_SUPPLIER_CONTACTS_VAL_V

Product:	PO - Purchasing
Description:	10SC ONLY - Retrofitted
Implementation/DBA Data:	APPS.PO_SUPPLIER_CONTACTS_VAL_V

View Text

SELECT (DECODE (FIRST_NAME
, NULL
, LAST_NAME
, LAST_NAME||'
, '||FIRST_NAME) ) CONTACT
, DECODE(TRUNC(LENGTH(AREA_CODE ||' '||PHONE)/26)
, 0
, AREA_CODE || DECODE(AREA_CODE
, NULL
, NULL
, DECODE(PHONE
, NULL
, NULL
, ' '))||PHONE
, AREA_CODE||PHONE ) TELEPHONE
, EMAIL_ADDRESS
, VENDOR_CONTACT_ID
, VENDOR_SITE_ID
FROM PO_VENDOR_CONTACTS
WHERE SYSDATE < NVL(INACTIVE_DATE
, SYSDATE + 1)

Columns