APPS.OE_ORDER_ADJ_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 393: FROM OE_ORDER_HEADERS_ALL

389: SELECT order_source_id, orig_sys_document_ref, change_sequence,
390: source_document_type_id, source_document_id
391: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
392: l_source_document_type_id, l_source_document_id
393: FROM OE_ORDER_HEADERS_ALL
394: WHERE header_id = l_header_adj_rec.header_Id;
395: EXCEPTION
396: WHEN NO_DATA_FOUND THEN
397: l_order_source_id := null;

Line 437: FROM OE_ORDER_HEADERS_ALL

433: SELECT order_source_id, orig_sys_document_ref, change_sequence,
434: source_document_type_id, source_document_id
435: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
436: l_source_document_type_id, l_source_document_id
437: FROM OE_ORDER_HEADERS_ALL
438: WHERE header_id = l_old_header_adj_rec.header_id;
439: EXCEPTION
440: WHEN NO_DATA_FOUND THEN
441: l_order_source_id := null;

Line 1714: FROM OE_ORDER_HEADERS_ALL

1710: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1711: source_document_type_id, source_document_id
1712: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1713: l_source_document_type_id, l_source_document_id
1714: FROM OE_ORDER_HEADERS_ALL
1715: WHERE header_id = l_header_Price_Att_rec.header_Id;
1716: EXCEPTION
1717: WHEN NO_DATA_FOUND THEN
1718: l_order_source_id := null;

Line 1758: FROM OE_ORDER_HEADERS_ALL

1754: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1755: source_document_type_id, source_document_id
1756: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1757: l_source_document_type_id, l_source_document_id
1758: FROM OE_ORDER_HEADERS_ALL
1759: WHERE header_id = l_old_header_Price_Att_rec.header_Id;
1760: EXCEPTION
1761: WHEN NO_DATA_FOUND THEN
1762: l_order_source_id := null;

Line 10889: , oe_order_headers_all oh

10885: adj_debug('in ams mod check ');
10886: BEGIN
10887: SELECT 1 into l_tmp_no from dual where exists (
10888: select 1 from qp_list_headers_b qh
10889: , oe_order_headers_all oh
10890: where qh.currency_code = oh.transactional_curr_code
10891: and oh.header_id = l_header_id
10892: and qh.source_system_code='AMS'
10893: and qh.active_flag = 'Y');

Line 11740: /*Select booked_flag into l_booked_flag from oe_order_headers_all

11736: else
11737: OE_ORDER_CACHE.Load_Order_Header(l_header_id);
11738: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11739: end if ;
11740: /*Select booked_flag into l_booked_flag from oe_order_headers_all
11741: where header_id=l_header_id; */
11742: --end bug 4200055
11743:
11744: If l_booked_flag <> 'Y' Then

Line 11783: Select booked_flag into l_booked_flag from oe_order_headers_all

11779: l_prev_org_id := l_org_id;
11780: END IF;
11781: IF l_prev_hdr_id IS NULL OR l_prev_hdr_id <> l_header_id THEN
11782: adj_debug('Price Action Header_id :'||l_HEader_id);
11783: Select booked_flag into l_booked_flag from oe_order_headers_all
11784: where header_id=l_header_id;
11785: If l_booked_flag <> 'Y' Then
11786: l_price_control_rec.pricing_event := 'BATCH';
11787: l_multiple_events := 'N';

Line 12011: Select booked_flag into l_booked_flag from oe_order_headers_all

12007:
12008: adj_debug('Price Action Header_id :'||l_HEader_id);
12009: -- End of changes for 2532740
12010:
12011: Select booked_flag into l_booked_flag from oe_order_headers_all
12012: where header_id=l_header_id;
12013:
12014: --Following code are commented out due to unresolved dependencies issue
12015: --with Oracle Pricing. However, this code will greatly improve performance