Operation Details
Description: Read resource transfer sanction details for a resource transfer sanction.
Sterotype: ns
SQL
SELECT
  RESOURCETRANSFER.itemType,
  RESOURCETRANSFER.transferDate,
  ISPTRANSFERSANCTIONLINK.durationOfDisqualification,
  RESOURCETRANSFER.uncompensatedValue,
  ISPTRANSFERSANCTIONLINK.disqualificationStartDate
INTO
  :itemType,
  :transferDate,
  :durationOfDisqualification,
  :uncompensatedValue,
  :disqualificationStartDate 
FROM
  ISPTRANSFERSANCTIONLINK,
  RESOURCETRANSFER 
WHERE ISPTRANSFERSANCTIONLINK.transferSanctionID = :transferSanctionID 
  AND RESOURCETRANSFER.evidenceID = ISPTRANSFERSANCTIONLINK.linkedID