VIEW: APPS.PO_SUPPLIER_CONTACTS_VAL_V

Source

View Text - Preformatted

SELECT first_name, (DECODE(hp.person_first_name,NULL,hp.person_last_name, hp.person_last_name ||', ' ||hp.person_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, last_name ||NVL2(first_name,', ' ||NVL2(pvc.prefix,prefix ||' ',NULL) | |first_name,NULL) full_name, last_name, NVL2(pvc.prefix,pvc.prefix ||' ',NULL) ||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,hz_parties HP WHERE pvc.per_party_id = fu.person_party_id(+) AND pvc.PER_PARTY_ID = hp.party_id

View Text - HTML Formatted

SELECT FIRST_NAME
, (DECODE(HP.PERSON_FIRST_NAME
, NULL
, HP.PERSON_LAST_NAME
, HP.PERSON_LAST_NAME ||'
, ' ||HP.PERSON_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
, LAST_NAME ||NVL2(FIRST_NAME
, '
, ' ||NVL2(PVC.PREFIX
, PREFIX ||' '
, NULL) | |FIRST_NAME
, NULL) FULL_NAME
, LAST_NAME
, NVL2(PVC.PREFIX
, PVC.PREFIX ||' '
, NULL) ||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
, HZ_PARTIES HP
WHERE PVC.PER_PARTY_ID = FU.PERSON_PARTY_ID(+)
AND PVC.PER_PARTY_ID = HP.PARTY_ID