SELECT
  JL.CMSJournalNo,
  JL.CMSJournalLineNo,
  JL.CMSInvNo,
  JL.ItemNumber,
  JL.CMSLineNo,
  JL.Description,
  JL.DebitAccount,
  JL.DebitBranchRegion,
  JL.DebitProductCategory,
  JL.DebitTaxType,
  JL.CreditAccount,
  JL.CreditBranchRegion,
  JL.CreditProductCategory,
  JL.CreditTaxType,
  JL.LineAmount,
  JL.LinkCMSInvNo,
  JL.LinkItemNumber,
  JL.LinkCMSLineNo
FROM
  taManualJournalLine AS JL
WHERE
  JL.CMSJournalNo = @nCMSJournalNo
ORDER BY
  JL.CMSJournalLineNo