PO_SUPPLIER_CONTACTS_VAL_V

Details

• Schema: FUSION

• Object owner: PO

• Object type: VIEW

Columns

Name
FIRST_NAME CONTACT TELEPHONE EMAIL_ADDRESS VENDOR_CONTACT_ID VENDOR_SITE_ID FULL_NAME LAST_NAME PREFIX_FIRST_NAME FAX_NUMBER

Query

SQL_Statement

SELECT FIRST_NAME,(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, LAST_NAME || NVL2(FIRST_NAME, ', ' || NVL2(PREFIX, PREFIX || ' ', NULL) || FIRST_NAME, NULL ) FULL_NAME, LAST_NAME, NVL2(PREFIX, PREFIX || ' ', NULL) || FIRST_NAME PREFIX_FIRST_NAME, FAX_AREA_CODE || NVL2(FAX_AREA_CODE, NVL2(FAX, ' ', NULL), NULL ) || FAX FAX_NUMBER FROM POZ_SUPPLIER_CONTACTS_V WHERE SYSDATE < NVL(INACTIVE_DATE, SYSDATE + 1)