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 OZF_ORDER_GROUP_PROD

Line 10: -- 04/20/2007 inanaiah fixed bug 5975678 - handled creation/update of ozf_order_group_prod records for Splits

6: --
7: -- HISTORY
8: -- 02/23/2007 kdass fixed bug 5754500 - if the order_line_id is being passed as a result
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

Line 65: FROM ozf_order_group_prod

61: WHERE list_line_id = p_list_line_id;
62:
63: CURSOR c_existing_values(p_indirect_flag VARCHAR2,l_order_line_id NUMBER) IS
64: SELECT group_no, volume_track_type, combine_schedule_yn, pbh_line_id, prod_attribute, prod_attr_value
65: FROM ozf_order_group_prod
66: WHERE order_line_id = l_order_line_id
67: AND indirect_flag = p_indirect_flag
68: AND offer_id = p_offer_id;
69:

Line 185: FROM ozf_order_group_prod

181: )
182: IS
183: CURSOR c_group_prod(p_offer_id NUMBER, p_line_id NUMBER, p_indirect_flag VARCHAR2) IS
184: SELECT group_no, volume_track_type, combine_schedule_yn, pbh_line_id, volume_type, include_volume_flag
185: FROM ozf_order_group_prod
186: WHERE offer_id = p_offer_id
187: AND order_line_id = p_line_id
188: AND indirect_flag = p_indirect_flag;
189:

Line 240: FROM ozf_order_group_prod

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
239: SELECT offer_id, qp_list_header_id, group_no, volume_track_type, combine_schedule_yn, pbh_line_id, volume_type, prod_attribute, prod_attr_value, apply_discount_flag, include_volume_flag, indirect_flag
240: FROM ozf_order_group_prod
241: WHERE offer_id = p_offer_id
242: AND order_line_id = p_line_id
243: AND indirect_flag = p_indirect_flag;
244: l_rma_ref_line_detail c_rma_ref_line_detail%ROWTYPE;

Line 290: INSERT INTO ozf_order_group_prod

286: OPEN c_rma_ref_line_detail(p_offer_id, l_order_line_type.reference_line_id, p_indirect_flag);
287: FETCH c_rma_ref_line_detail INTO l_rma_ref_line_detail;
288: CLOSE c_rma_ref_line_detail;
289:
290: INSERT INTO ozf_order_group_prod
291: (
292: order_group_prod_id
293: ,creation_date
294: ,created_by

Line 313: ( ozf_order_group_prod_s.NEXTVAL

309: ,include_volume_flag
310: ,indirect_flag
311: )
312: VALUES
313: ( ozf_order_group_prod_s.NEXTVAL
314: ,SYSDATE
315: ,FND_GLOBAL.user_id
316: ,SYSDATE
317: ,FND_GLOBAL.user_id

Line 1811: FROM ozf_order_group_prod

1807: WHERE resale_line_id = p_order_line_id;
1808:
1809: CURSOR c_combine_schedule(l_qp_list_header_id NUMBER, l_order_line_id NUMBER) IS
1810: SELECT offer_id, combine_schedule_yn, apply_discount_flag, group_no, volume_track_type, pbh_line_id
1811: FROM ozf_order_group_prod
1812: WHERE qp_list_header_id = l_qp_list_header_id
1813: AND order_line_id = l_order_line_id
1814: AND indirect_flag = DECODE(p_source_code, 'OM', 'O', 'IS', 'R');
1815:

Line 1979: FROM ozf_order_group_prod

1975: AND offer_id = p_offer_id;
1976:
1977: CURSOR c_order_group_prod_id(p_offer_id NUMBER, p_line_id NUMBER, p_indirect_flag VARCHAR2) IS
1978: SELECT order_group_prod_id
1979: FROM ozf_order_group_prod
1980: WHERE order_line_id = p_line_id
1981: AND offer_id = p_offer_id
1982: AND indirect_flag = p_indirect_flag;
1983:

Line 2137: -- For the second, third,...splits, the selected split records need to be created/updated in ozf_order_group_prod

2133: IF (p_order_line_id = l_split_from_line_id) THEN
2134: -- This happens when SO is split, the first child split has the same line_id as the parent SO
2135: l_group_prod_order_line_id := l_split_from_line_id;
2136: ELSE
2137: -- For the second, third,...splits, the selected split records need to be created/updated in ozf_order_group_prod
2138: -- In the earlier version the l_split_from_line_id record of ozf_order_group_prod was updated with
2139: -- order_line_id = p_order_line_id
2140: -- resulting in losing the l_split_from_line_id record in ozf_order_group_prod.
2141: l_group_prod_order_line_id := p_order_line_id;

Line 2138: -- In the earlier version the l_split_from_line_id record of ozf_order_group_prod was updated with

2134: -- This happens when SO is split, the first child split has the same line_id as the parent SO
2135: l_group_prod_order_line_id := l_split_from_line_id;
2136: ELSE
2137: -- For the second, third,...splits, the selected split records need to be created/updated in ozf_order_group_prod
2138: -- In the earlier version the l_split_from_line_id record of ozf_order_group_prod was updated with
2139: -- order_line_id = p_order_line_id
2140: -- resulting in losing the l_split_from_line_id record in ozf_order_group_prod.
2141: l_group_prod_order_line_id := p_order_line_id;
2142: END IF;

Line 2140: -- resulting in losing the l_split_from_line_id record in ozf_order_group_prod.

2136: ELSE
2137: -- For the second, third,...splits, the selected split records need to be created/updated in ozf_order_group_prod
2138: -- In the earlier version the l_split_from_line_id record of ozf_order_group_prod was updated with
2139: -- order_line_id = p_order_line_id
2140: -- resulting in losing the l_split_from_line_id record in ozf_order_group_prod.
2141: l_group_prod_order_line_id := p_order_line_id;
2142: END IF;
2143: END IF;
2144: END IF;

Line 2151: INSERT INTO ozf_order_group_prod

2147: FETCH c_order_group_prod_id INTO l_id;
2148: CLOSE c_order_group_prod_id;
2149:
2150: IF l_id IS NULL THEN
2151: INSERT INTO ozf_order_group_prod
2152: (
2153: order_group_prod_id
2154: ,creation_date
2155: ,created_by

Line 2174: ( ozf_order_group_prod_s.NEXTVAL

2170: ,include_volume_flag
2171: ,indirect_flag
2172: )
2173: VALUES
2174: ( ozf_order_group_prod_s.NEXTVAL
2175: ,SYSDATE
2176: ,FND_GLOBAL.user_id
2177: ,SYSDATE
2178: ,FND_GLOBAL.user_id

Line 2195: UPDATE ozf_order_group_prod

2191: ,l_include_volume
2192: ,l_indirect_flag
2193: );
2194: ELSE
2195: UPDATE ozf_order_group_prod
2196: SET last_update_date = SYSDATE,
2197: last_updated_by = FND_GLOBAL.user_id,
2198: last_update_login = FND_GLOBAL.conc_login_id,
2199: order_line_id = p_order_line_id,

Line 2335: FROM ozf_order_group_prod

2331: */
2332: --04-MAY-09 kdass bug 8421406
2333: CURSOR c_group_no IS
2334: SELECT group_no
2335: FROM ozf_order_group_prod
2336: WHERE offer_id = p_offer_id
2337: AND order_line_id = p_order_line_id;
2338:
2339: /*

Line 2391: UPDATE ozf_order_group_prod

2387: SAVEPOINT update_tracking_line;
2388:
2389: x_return_status := Fnd_Api.g_ret_sts_success;
2390:
2391: UPDATE ozf_order_group_prod
2392: SET order_line_id = p_resale_line_id,
2393: indirect_flag = 'R'
2394: WHERE qp_list_header_id = p_list_header_id
2395: AND order_line_id = p_interface_line_id

Line 2644: --It will take all the values of the original order line and will copy the same for new order line in ozf_order_group_prod table.

2640: END;
2641:
2642: --nirprasa, added function for bug 9027785
2643: --This function will be called by OM directly whenever order copy functionality is used at original price.
2644: --It will take all the values of the original order line and will copy the same for new order line in ozf_order_group_prod table.
2645:
2646: FUNCTION copy_order_group_details
2647: ( p_from_order_line_id IN NUMBER
2648: ,p_to_order_line_id IN NUMBER

Line 2668: FROM ozf_order_group_prod

2664: and line_id= p_to_order_line_id;
2665:
2666: CURSOR c_existing_lines IS
2667: SELECT group_no, volume_track_type, combine_schedule_yn, pbh_line_id, prod_attribute, prod_attr_value,qp_list_header_id
2668: FROM ozf_order_group_prod
2669: WHERE order_line_id = p_from_order_line_id
2670: AND indirect_flag = 'O';
2671: --AND qp_list_header_id = p_list_header_id;
2672: