eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_VOLUME_CALCULATION_PUB dependencies on OE_ORDER_LINES_ALL

Line 13: -- 06/22/2007 nirprasa fixed bug 6140749 - changed OE_ORDER_LINES to OE_ORDER_LINES_ALL

9: -- of a split, then use split_from_line_id in the call to the cursor.
10: -- 04/20/2007 inanaiah fixed bug 5975678 - handled creation/update of ozf_order_group_prod records for Splits
11: -- 05/10/2007 nirprasa fixed bug 6021635 - changed cursor c_offer_id_om for backdated adjustments created for booked orders.
12: -- 05/14/2007 kdass fixed bug 6008340
13: -- 06/22/2007 nirprasa fixed bug 6140749 - changed OE_ORDER_LINES to OE_ORDER_LINES_ALL
14: -- 09/19/2008 nirprasa fixed bug 6998502 - VOLUME OFFERS ARE NOT APPLIED CORRECTLY ON A SALES ORDER
15: -- 09/19/2008 nirprasa fixed bug 7353241 - VOLUME OFFER CALCULATIONS INCORRECT FOR SINGLE UNIT ACCRUALS
16: -- 11/24/2008 nirprasa fixed bug 7030415 - R12SIP WE CAN'T SETUP CURRENY CONVERSION TYPE FOR SPECIFIC OPERATING UNIT
17: -- 05/04/2009 kdass fixed bug 8421406 - BENEFICIARY WITHIN THE MARKET OPTIONS DO NOT WORK

Line 72: FROM OE_ORDER_LINES_ALL

68: AND offer_id = p_offer_id;
69:
70: CURSOR c_split_from_line_id (p_order_line_id NUMBER) IS
71: SELECT split_from_line_id
72: FROM OE_ORDER_LINES_ALL
73: WHERE line_id = p_order_line_id; --AMITAMKU fixed Bug 14262288
74:
75: l_precedence NUMBER := fnd_api.g_miss_num;
76: l_dummy1 NUMBER;

Line 104: -- select split_from_line_id into l_split_from_line_id from OE_ORDER_LINES_ALL where line_id = p_order_line_id;

100: l_group_prod_order_line_id := p_order_line_id;
101:
102: IF x_indirect_flag = 'O' THEN
103: -- AMITAMKU fixed bug 14262288, Commented select statement and added open,fetch and close cursor statement to avoid NO_DATA_FOUND exception
104: -- select split_from_line_id into l_split_from_line_id from OE_ORDER_LINES_ALL where line_id = p_order_line_id;
105:
106: l_split_from_line_id := NULL;
107: OPEN c_split_from_line_id (p_order_line_id);
108: FETCH c_split_from_line_id INTO l_split_from_line_id;

Line 234: FROM oe_order_lines_all

230: WHERE offer_id = p_offer_id;
231:
232: CURSOR c_order_line_type(p_line_id NUMBER) IS
233: SELECT reference_header_id, reference_line_id, line_category_code, return_context, return_attribute1, return_attribute2
234: FROM oe_order_lines_all
235: WHERE line_id = p_line_id;
236: l_order_line_type c_order_line_type%ROWTYPE;
237:
238: CURSOR c_rma_ref_line_detail(p_offer_id NUMBER, p_line_id NUMBER, p_indirect_flag VARCHAR2) IS

Line 344: select split_from_line_id into l_split_from_line_id from OE_ORDER_LINES_ALL where line_id = p_volume_detail_rec.line_id;

340: FETCH c_group_prod INTO l_group_no, l_volume_track_type, l_combine_schedule_yn, l_pbh_line_id, l_volume_type, l_include_volume;
341: CLOSE c_group_prod;
342:
343: IF p_indirect_flag = 'O' THEN
344: select split_from_line_id into l_split_from_line_id from OE_ORDER_LINES_ALL where line_id = p_volume_detail_rec.line_id;
345: IF (l_split_from_line_id IS NOT NULL) THEN
346: ozf_utility_pvt.write_conc_log('split_from_line_id: ' || l_split_from_line_id);
347: OPEN c_group_prod(p_offer_id, l_split_from_line_id, p_indirect_flag);
348: FETCH c_group_prod INTO l_group_no, l_volume_track_type, l_combine_schedule_yn, l_pbh_line_id, l_volume_type, l_include_volume;

Line 1862: SELECT split_from_line_id into l_split_from_line_id from OE_ORDER_LINES_ALL where line_id = p_order_line_id;

1858: FETCH c_combine_schedule INTO l_offer_id, l_combine_schedule, l_apply_discount, l_group_no, l_volume_track_type, l_pbh_line_id;
1859: CLOSE c_combine_schedule;
1860:
1861: IF p_source_code = 'OM' THEN
1862: SELECT split_from_line_id into l_split_from_line_id from OE_ORDER_LINES_ALL where line_id = p_order_line_id;
1863: IF (l_split_from_line_id IS NOT NULL) then
1864: OPEN c_combine_schedule(p_qp_list_header_id, l_split_from_line_id);
1865: FETCH c_combine_schedule INTO l_offer_id, l_combine_schedule, l_apply_discount, l_group_no, l_volume_track_type, l_pbh_line_id;
1866: CLOSE c_combine_schedule;

Line 1956: FROM oe_order_lines_all

1952: AND q.list_line_id = p_list_line_id;
1953:
1954: CURSOR c_order_detail IS
1955: SELECT unit_selling_price, pricing_quantity, sold_to_org_id, ship_to_org_id, invoice_to_org_id, actual_shipment_date
1956: FROM oe_order_lines_all
1957: WHERE line_id = p_order_line_id;
1958:
1959: CURSOR c_resale_detail IS
1960: SELECT quantity, amount, sold_from_cust_account_id, sold_to_cust_account_id, ship_to_site_use_id, bill_to_site_use_id, transaction_date

Line 2000: FROM OE_ORDER_LINES_ALL

1996: AND c.group_number = p_group_no;
1997:
1998: CURSOR c_split_from_line_id (p_order_line_id NUMBER) IS
1999: SELECT split_from_line_id
2000: FROM OE_ORDER_LINES_ALL
2001: WHERE line_id = p_order_line_id; --AMITAMKU fixed Bug 14262288
2002:
2003: l_list_header_id NUMBER;
2004: l_offer_id NUMBER;

Line 2123: --select split_from_line_id into l_split_from_line_id from OE_ORDER_LINES_ALL where line_id = p_order_line_id;

2119: l_group_prod_order_line_id := p_order_line_id;
2120:
2121: IF l_indirect_flag = 'O' THEN
2122: -- AMITAMKU fixed bug 14262288, Commented select statement and added open,fetch and close cursor statement to avoid NO_DATA_FOUND exception
2123: --select split_from_line_id into l_split_from_line_id from OE_ORDER_LINES_ALL where line_id = p_order_line_id;
2124:
2125: l_split_from_line_id := NULL;
2126: OPEN c_split_from_line_id (p_order_line_id);
2127: FETCH c_split_from_line_id INTO l_split_from_line_id;