Operation Details
Description: Reads organization tab display details.
Sterotype: ns
SQL 
SELECT
  Organisation.name,
  Organisation.taxNumber,
  Organisation.registrationNumber,
  Organisation.description,
  Organisation.webAddress,
  Address.addressData,
  EmailAddress.emailAddress,
  PhoneNumber.phoneNumberID
INTO
  :name,
  :taxNumber,
  :registrationNumber,
  :description,
  :webAddress,
  :addressData,
  :emailAddress,
  :phoneNumberID
FROM
  Organisation 
  LEFT OUTER JOIN
  Address 
  ON Address.addressID = Organisation.addressID 
  LEFT OUTER JOIN
  EmailAddress 
  ON EmailAddress.emailAddressID = Organisation.emailAddressID 
  LEFT OUTER JOIN
  PhoneNumber 
  ON PhoneNumber.phoneNumberID = Organisation.phoneNumberID 
WHERE Organisation.organisationID = :organisationID