Operation Details
Description: Read details for auto resource transfer type.
Sterotype: ns
SQL 
SELECT
  ISPAUTOResourceTransfer.itemType,
  ISPAUTOResourceTransfer.transferDate,
  ISPTRANSFERSANCTIONLINK.durationOfDisqualification,
  ISPAUTOResourceTransfer.uncompensatedValue,
  ISPTRANSFERSANCTIONLINK.disqualificationStartDate
INTO
  :itemType,
  :transferDate,
  :durationOfDisqualification,
  :uncompensatedValue,
  :disqualificationStartDate 
FROM
  ISPTRANSFERSANCTIONLINK,
  ISPAUTOResourceTransfer 
WHERE ISPTRANSFERSANCTIONLINK.transferSanctionID = :transferSanctionID 
  AND ISPAUTOResourceTransfer.autoResourceTransferID = ISPTRANSFERSANCTIONLINK.linkedID