Operation Details
Description: Retrieves the quick link details from the quick link and web address entities.
Sterotype: ns
SQL 
SELECT
  QuickLink.name,
  QuickLink.dateCreated,
  QuickLink.webAddressID,
  QuickLink.openInModalInd,
  QuickLink.versionNo,
  WebAddress.webAddress,
  WebAddress.statusCode,
  WebAddress.versionNo,
  WebAddress.comments
INTO
  :name,
  :dateCreated,
  :webAddressID,
  :openInModalInd,
  :versionNo,
  :webAddress,
  :statusCode,
  :webAddVersionNo,
  :comments 
FROM
  QuickLink,
  WebAddress 
WHERE QuickLink.quickLinkID = :quickLinkID 
  AND QuickLink.webAddressID = WebAddress.webAddressID