Operation Details
Description: Returns a list of phone numbers used by a specified contact
Sterotype: nsmulti
SQL 
SELECT
  typeCode,
  phoneAreaCode,
  phoneNumber,
  startDate,
  endDate,
  statusCode,
  contactPhoneNumberID,
  phoneExtension,
  phoneNumber.phoneNumberID,
  phoneNumber.versionNo,
  ContactPhoneNumber.versionNo
INTO
  :typeCode,
  :phoneAreaCode,
  :phoneNumber,
  :startDate,
  :endDate,
  :statusCode,
  :contactPhoneNumberID,
  :phoneExtension,
  :phoneNumberID,
  :phoneNumberVersionNo,
  :contactPhoneNumberVersionNo 
FROM
  phoneNumber,
  ContactPhoneNumber 
WHERE contactID = :contactID 
  AND phoneNumber.phoneNumberID = ContactPhoneNumber.phoneNumberID