APPS.OE_ORDER_ADJ_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 394: FROM OE_ORDER_HEADERS_ALL

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

Line 438: FROM OE_ORDER_HEADERS_ALL

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

Line 1797: FROM OE_ORDER_HEADERS_ALL

1793: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1794: source_document_type_id, source_document_id
1795: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1796: l_source_document_type_id, l_source_document_id
1797: FROM OE_ORDER_HEADERS_ALL
1798: WHERE header_id = l_header_Price_Att_rec.header_Id;
1799: EXCEPTION
1800: WHEN NO_DATA_FOUND THEN
1801: l_order_source_id := null;

Line 1841: FROM OE_ORDER_HEADERS_ALL

1837: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1838: source_document_type_id, source_document_id
1839: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1840: l_source_document_type_id, l_source_document_id
1841: FROM OE_ORDER_HEADERS_ALL
1842: WHERE header_id = l_old_header_Price_Att_rec.header_Id;
1843: EXCEPTION
1844: WHEN NO_DATA_FOUND THEN
1845: l_order_source_id := null;

Line 10997: , oe_order_headers_all oh

10993: adj_debug('in ams mod check ');
10994: BEGIN
10995: SELECT 1 into l_tmp_no from dual where exists (
10996: select 1 from qp_list_headers_b qh
10997: , oe_order_headers_all oh
10998: where qh.currency_code = oh.transactional_curr_code
10999: and oh.header_id = l_header_id
11000: and qh.source_system_code='AMS'
11001: and qh.active_flag = 'Y');

Line 11851: /*Select booked_flag into l_booked_flag from oe_order_headers_all

11847: else
11848: OE_ORDER_CACHE.Load_Order_Header(l_header_id);
11849: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11850: end if ;
11851: /*Select booked_flag into l_booked_flag from oe_order_headers_all
11852: where header_id=l_header_id; */
11853: --end bug 4200055
11854:
11855: If l_booked_flag <> 'Y' Then

Line 11908: Select booked_flag into l_booked_flag from oe_order_headers_all

11904: l_prev_org_id := l_org_id;
11905: END IF;
11906: IF l_prev_hdr_id IS NULL OR l_prev_hdr_id <> l_header_id THEN
11907: adj_debug('Price Action Header_id :'||l_HEader_id);
11908: Select booked_flag into l_booked_flag from oe_order_headers_all
11909: where header_id=l_header_id;
11910: If l_booked_flag <> 'Y' Then
11911: l_price_control_rec.pricing_event := 'BATCH';
11912: l_multiple_events := 'N';

Line 12152: Select booked_flag into l_booked_flag from oe_order_headers_all

12148:
12149: adj_debug('Price Action Header_id :'||l_HEader_id);
12150: -- End of changes for 2532740
12151:
12152: Select booked_flag into l_booked_flag from oe_order_headers_all
12153: where header_id=l_header_id;
12154:
12155: --Following code are commented out due to unresolved dependencies issue
12156: --with Oracle Pricing. However, this code will greatly improve performance