514: SELECT
515: CANCELLED_QUANTITY
516: INTO CAN_QTY_1
517: FROM
518: OE_ORDER_LINES_ALL
519: WHERE LINE_ID = LINEID;
520: RETURN (CAN_QTY_1);
521: ELSE
522: SELECT
531: SELECT
532: ( CANCELLED_QUANTITY - CAN_QTY_MAX )
533: INTO CAN_QTY_FINAL1
534: FROM
535: OE_ORDER_LINES_ALL
536: WHERE LINE_ID = LINEID;
537: RETURN (CAN_QTY_FINAL1);
538: ELSE
539: SELECT
577: CANCELLED_QUANTITY,
578: UNIT_SELLING_PRICE
579: INTO CAN_QTY_1,UNIT_SELLING_PRICE_VAR
580: FROM
581: OE_ORDER_LINES_ALL
582: WHERE LINE_ID = LINEID;
583: RETURN (CAN_QTY_1 * UNIT_SELLING_PRICE_VAR);
584: ELSE
585: SELECT
595: ( CANCELLED_QUANTITY - CAN_QTY_MAX ),
596: UNIT_SELLING_PRICE
597: INTO CAN_QTY_FINAL1,UNIT_SELLING_PRICE_VAR
598: FROM
599: OE_ORDER_LINES_ALL
600: WHERE LINE_ID = LINEID;
601: RETURN (CAN_QTY_FINAL1 * UNIT_SELLING_PRICE_VAR);
602: ELSE
603: SELECT