Operation Details
Description: reads product provider name and address details by concern role ID.
Sterotype: nsmulti
SQL 
SELECT
  name,
  addressData,
  primaryPhoneNumberID,
  primaryEmailAddressID
INTO
  :name,
  :addressData,
  :primaryPhoneNumberID,
  :primaryEmailAddressID 
FROM
  ProductProvider,
  ConcernRole,
  Address 
WHERE 
  (
    ProductProvider.concernRoleID = :concernRoleID 
    AND ProductProvider.concernRoleID = ConcernRole.concernRoleID 
    AND Address.addressID = ConcernRole.primaryAddressID 
  )