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
182: WHEN OTHERS THEN
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
571: WHEN OTHERS THEN