APPS.OE_BLANKET_PRICING_UTIL dependencies on OE_BLANKET_HEADERS_ALL

Line 166: FROM oe_blanket_headers_ext he, oe_blanket_headers_all h

162: l_blanket_header_id := l_request_rec.param6;
163:
164: SELECT /* MOAC_SQL_CHANGE */ he.new_modifier_list_id
165: INTO l_modifier_list_id
166: FROM oe_blanket_headers_ext he, oe_blanket_headers_all h
167: WHERE h.header_id = l_blanket_header_id
168: AND he.order_number = h.order_number
169: AND h.org_id = mo_global.get_current_org_id;
170:

Line 392: from oe_blanket_headers_all

388:
389: update oe_blanket_headers_ext
390: set new_modifier_list_id = l_x_modifier_list_rec.list_header_id
391: where order_number = (select /* MOAC_SQL_CHANGE */ order_number
392: from oe_blanket_headers_all
393: where header_id = l_blanket_header_id
394: and org_id = mo_global.get_current_org_id);
395:
396: oe_delayed_requests_pvt.g_delayed_requests.delete(l_hdr_req_index);

Line 762: from oe_blanket_headers_all

758: AND p_blanket_number <> FND_API.G_MISS_NUM
759: THEN
760: select /* MOAC_SQL_CHANGE */ header_id
761: into l_blanket_header_id
762: from oe_blanket_headers_all
763: where order_number = p_blanket_number
764: and org_id = mo_global.get_current_org_id;
765: END IF;
766:

Line 936: from oe_blanket_headers_ext bhe, oe_blanket_headers_all bh

932: ,bh.header_id
933: into l_released_amount
934: ,l_returned_amount
935: ,l_blanket_header_id
936: from oe_blanket_headers_ext bhe, oe_blanket_headers_all bh
937: where bhe.order_number = p_blanket_number
938: and bhe.order_number = bh.order_number
939: and bh.org_id = mo_global.get_current_orG_id;
940: oe_debug_pub.add('current blkt rel amt :'||l_released_amount);