APPS.OE_BLANKET_PRICING_UTIL dependencies on OE_BLANKET_HEADERS_ALL

Line 145: FROM oe_blanket_headers_ext he, oe_blanket_headers_all h

141: l_blanket_header_id := l_request_rec.param6;
142:
143: SELECT /* MOAC_SQL_CHANGE */ he.new_modifier_list_id
144: INTO l_modifier_list_id
145: FROM oe_blanket_headers_ext he, oe_blanket_headers_all h
146: WHERE h.header_id = l_blanket_header_id
147: AND he.order_number = h.order_number
148: AND h.org_id = mo_global.get_current_org_id;
149:

Line 371: from oe_blanket_headers_all

367:
368: update oe_blanket_headers_ext
369: set new_modifier_list_id = l_x_modifier_list_rec.list_header_id
370: where order_number = (select /* MOAC_SQL_CHANGE */ order_number
371: from oe_blanket_headers_all
372: where header_id = l_blanket_header_id
373: and org_id = mo_global.get_current_org_id);
374:
375: oe_delayed_requests_pvt.g_delayed_requests.delete(l_hdr_req_index);

Line 741: from oe_blanket_headers_all

737: AND p_blanket_number <> FND_API.G_MISS_NUM
738: THEN
739: select /* MOAC_SQL_CHANGE */ header_id
740: into l_blanket_header_id
741: from oe_blanket_headers_all
742: where order_number = p_blanket_number
743: and org_id = mo_global.get_current_org_id;
744: END IF;
745:

Line 915: from oe_blanket_headers_ext bhe, oe_blanket_headers_all bh

911: ,bh.header_id
912: into l_released_amount
913: ,l_returned_amount
914: ,l_blanket_header_id
915: from oe_blanket_headers_ext bhe, oe_blanket_headers_all bh
916: where bhe.order_number = p_blanket_number
917: and bhe.order_number = bh.order_number
918: and bh.org_id = mo_global.get_current_orG_id;
919: oe_debug_pub.add('current blkt rel amt :'||l_released_amount);