pears.NetOrderReasonList

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOrderReasonList" IS 
{CREATE FUNCTION pears."NetOrderReasonList"()
RETURNS long VARCHAR
//IQXWeb
BEGIN
  DECLARE "rv" long VARCHAR;
  SELECT "list"("string"("tempshiftorderreasonid",']~[',"description"),']~[' ORDER BY "sortorder" ASC,"description" ASC) INTO "rv" FROM "tempshiftorderreason";
  RETURN "rv"
END
 
/* DOC
2016-10-20 PC modify to include doc and test
 
inputs:
    none
 
outputs:
    delimited list
 
tests:
    test inherited through NetClientShiftOrderReasons
 
*/
 
/* TEST
 
*/
}