161: SELECT
162: ORDER_NUMBER
163: INTO L_QUALIFIER_ATTR_VALUE
164: FROM
165: OE_BLANKET_HEADERS_ALL
166: WHERE HEADER_ID = QUALIFIER_ATTR_VALUE;
167: EXCEPTION
168: WHEN OTHERS THEN
169: NULL;
173: SELECT
174: H.ORDER_NUMBER || '-' || L.LINE_NUMBER
175: INTO L_QUALIFIER_ATTR_VALUE
176: FROM
177: OE_BLANKET_HEADERS_ALL H,
178: OE_BLANKET_LINES_ALL L
179: WHERE L.LINE_ID = QUALIFIER_ATTR_VALUE
180: AND H.HEADER_ID = L.HEADER_ID;
181: EXCEPTION
550: SELECT
551: ORDER_NUMBER
552: INTO L_QUALIFIER_ATTR_VALUE_TO
553: FROM
554: OE_BLANKET_HEADERS_ALL
555: WHERE HEADER_ID = QUALIFIER_ATTR_VALUE_TO;
556: EXCEPTION
557: WHEN OTHERS THEN
558: NULL;
562: SELECT
563: H.ORDER_NUMBER || '-' || L.LINE_NUMBER
564: INTO L_QUALIFIER_ATTR_VALUE_TO
565: FROM
566: OE_BLANKET_HEADERS_ALL H,
567: OE_BLANKET_LINES_ALL L
568: WHERE L.LINE_ID = QUALIFIER_ATTR_VALUE_TO
569: AND H.HEADER_ID = L.HEADER_ID;
570: EXCEPTION