VIEW: APPS.PO_SUPPLIER_CONTACTS_VAL_V

Source

View Text - Preformatted

SELECT pvc.first_name, (DECODE(pvc.first_name,NULL,pvc.last_name, pvc.last_name ||', ' ||pvc.first_name)) contact, DECODE(TRUNC(LENGTH(pvc.area_code ||' ' ||pvc.phone) / 26),0,pvc.area_code ||DECODE(pvc.area_code,NULL,NULL, DECODE(pvc.phone,NULL,NULL, ' ')) ||pvc.phone, pvc.area_code ||pvc.phone) telephone, pvc.email_address, pvc.vendor_contact_id, pvc.vendor_site_id, pvc.last_name ||NVL2(pvc.first_name,', ' ||NVL2(pvc.prefix,prefix ||' ',NULL) ||pvc.first_name,NULL) full_name, pvc.last_name, NVL2(pvc.prefix,pvc.prefix ||' ',NULL) ||pvc.first_name prefix_first_name, pvc.fax_area_code ||NVL2(pvc.fax_area_code,NVL2(pvc.fax,' ',NULL), NULL) ||pvc.fax fax_number, fu.user_name FROM po_vendor_contacts pvc, fnd_user fu, ak_web_user_sec_attr_values ak WHERE fu.user_id (+)= ak.web_user_id AND ak.attribute_code (+)= 'ICX_SUPPLIER_CONTACT_ID' AND ak.attribute_application_id (+)= 177 AND ak.number_value (+)= pvc.vendor_contact_id AND SYSDATE < NVL(pvc.inactive_date,SYSDATE + 1) AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(fu.start_date),TRUNC(SYSDATE)) AND NVL(TRUNC(fu.end_date),TRUNC(SYSDATE))

View Text - HTML Formatted

SELECT PVC.FIRST_NAME
, (DECODE(PVC.FIRST_NAME
, NULL
, PVC.LAST_NAME
, PVC.LAST_NAME ||'
, ' ||PVC.FIRST_NAME)) CONTACT
, DECODE(TRUNC(LENGTH(PVC.AREA_CODE ||' ' ||PVC.PHONE) / 26)
, 0
, PVC.AREA_CODE ||DECODE(PVC.AREA_CODE
, NULL
, NULL
, DECODE(PVC.PHONE
, NULL
, NULL
, ' ')) ||PVC.PHONE
, PVC.AREA_CODE ||PVC.PHONE) TELEPHONE
, PVC.EMAIL_ADDRESS
, PVC.VENDOR_CONTACT_ID
, PVC.VENDOR_SITE_ID
, PVC.LAST_NAME ||NVL2(PVC.FIRST_NAME
, '
, ' ||NVL2(PVC.PREFIX
, PREFIX ||' '
, NULL) ||PVC.FIRST_NAME
, NULL) FULL_NAME
, PVC.LAST_NAME
, NVL2(PVC.PREFIX
, PVC.PREFIX ||' '
, NULL) ||PVC.FIRST_NAME PREFIX_FIRST_NAME
, PVC.FAX_AREA_CODE ||NVL2(PVC.FAX_AREA_CODE
, NVL2(PVC.FAX
, ' '
, NULL)
, NULL) ||PVC.FAX FAX_NUMBER
, FU.USER_NAME
FROM PO_VENDOR_CONTACTS PVC
, FND_USER FU
, AK_WEB_USER_SEC_ATTR_VALUES AK
WHERE FU.USER_ID (+)= AK.WEB_USER_ID
AND AK.ATTRIBUTE_CODE (+)= 'ICX_SUPPLIER_CONTACT_ID'
AND AK.ATTRIBUTE_APPLICATION_ID (+)= 177
AND AK.NUMBER_VALUE (+)= PVC.VENDOR_CONTACT_ID
AND SYSDATE < NVL(PVC.INACTIVE_DATE
, SYSDATE + 1)
AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(FU.START_DATE)
, TRUNC(SYSDATE))
AND NVL(TRUNC(FU.END_DATE)
, TRUNC(SYSDATE))