BLANKET SALES AGREEMENT TABLES, TO FIND PROMOTION/MODIFIER APPLIED ON AN ORDER:

BLANKET SALES AGREEMENT TABLES

select * from apps.OE_BLANKET_HEADERS_ALL where order_number=1000322464

select * from apps.OE_BLANKET_LINES_ALL where header_id= 35449389 and line_number='99'

select * from apps.oe_blanket_lines_ext where line_id=225600422



TO FIND PROMOTION/MODIFIER APPLIED ON AN ORDER:

select * from apps.oe_order_headers_all where order_number='1001346058'

select * from apps.OE_PRICE_ADJUSTMENTS where header_id=211242250;

select * from apps.QP_LIST_HEADERS_TL where list_header_id=23039;