DBA Data[Home] [Help]

APPS.QP_QPXPRCST_XMLP_PKG dependencies on OE_BLANKET_HEADERS_ALL

Line 165: OE_BLANKET_HEADERS_ALL

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;

Line 177: OE_BLANKET_HEADERS_ALL H,

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

Line 554: OE_BLANKET_HEADERS_ALL

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;

Line 566: OE_BLANKET_HEADERS_ALL H,

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