DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on OE_ORDER_HEADERS

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 2085: From OE_Order_Headers where

2081: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
2082: end if ;
2083: /*Select booked_flag Into
2084: l_booked_flag
2085: From OE_Order_Headers where
2086: Header_id = l_Header_Price_Att_Rec.Header_Id;
2087: Exception when no_data_found then
2088: Null;
2089: -- we shouldn't supress no_data_found error.

Line 4094: from oe_transaction_types_all o,oe_order_headers h

4090: G_STMT_NO := 'Enforce_Price_lists_Flag#10';
4091: IF (px_order_enforce_list_price IS NULL) THEN
4092: begin
4093: select /* MOAC_SQL_CHANGE */ nvl(enforce_line_prices_flag,'N') into px_order_enforce_list_price
4094: from oe_transaction_types_all o,oe_order_headers h
4095: where h.header_id=p_header_id and h.order_type_id=o.transaction_type_id
4096: and o.transaction_type_code=l_literal_order;
4097: exception when no_data_found then
4098: px_order_enforce_list_price := 'N';

Line 8900: select nvl(transactional_curr_code,'USD') into l_currency_code from oe_order_headers

8896: l_ext_precision number;
8897: l_min_acct_unit number;
8898: begin
8899: begin
8900: select nvl(transactional_curr_code,'USD') into l_currency_code from oe_order_headers
8901: where header_id=p_header_id;
8902: exception when no_data_found then
8903: l_currency_code := 'USD';
8904: end ;

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