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 58: FROM ozf_order_group_prod

54: WHERE list_line_id = p_list_line_id;
55:
56: CURSOR c_existing_values(p_indirect_flag VARCHAR2,l_order_line_id NUMBER) IS
57: SELECT group_no, volume_track_type, combine_schedule_yn, pbh_line_id, prod_attribute, prod_attr_value
58: FROM ozf_order_group_prod
59: WHERE order_line_id = l_order_line_id
60: AND indirect_flag = p_indirect_flag
61: AND offer_id = p_offer_id;
62:

Line 163: FROM ozf_order_group_prod

159: ,p_sign IN NUMBER)
160: IS
161: CURSOR c_group_prod(p_offer_id NUMBER, p_line_id NUMBER, p_indirect_flag VARCHAR2) IS
162: SELECT group_no, volume_track_type, combine_schedule_yn, pbh_line_id, volume_type, include_volume_flag
163: FROM ozf_order_group_prod
164: WHERE offer_id = p_offer_id
165: AND order_line_id = p_line_id
166: AND indirect_flag = p_indirect_flag;
167:

Line 209: FROM ozf_order_group_prod

205: l_order_line_type c_order_line_type%ROWTYPE;
206:
207: CURSOR c_rma_ref_line_detail(p_offer_id NUMBER, p_line_id NUMBER, p_indirect_flag VARCHAR2) IS
208: 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
209: FROM ozf_order_group_prod
210: WHERE offer_id = p_offer_id
211: AND order_line_id = p_line_id
212: AND indirect_flag = p_indirect_flag;
213: l_rma_ref_line_detail c_rma_ref_line_detail%ROWTYPE;

Line 259: INSERT INTO ozf_order_group_prod

255: OPEN c_rma_ref_line_detail(p_offer_id, l_order_line_type.reference_line_id, p_indirect_flag);
256: FETCH c_rma_ref_line_detail INTO l_rma_ref_line_detail;
257: CLOSE c_rma_ref_line_detail;
258:
259: INSERT INTO ozf_order_group_prod
260: (
261: order_group_prod_id
262: ,creation_date
263: ,created_by

Line 282: ( ozf_order_group_prod_s.NEXTVAL

278: ,include_volume_flag
279: ,indirect_flag
280: )
281: VALUES
282: ( ozf_order_group_prod_s.NEXTVAL
283: ,SYSDATE
284: ,FND_GLOBAL.user_id
285: ,SYSDATE
286: ,FND_GLOBAL.user_id

Line 1381: FROM ozf_order_group_prod

1377: WHERE resale_line_id = p_order_line_id;
1378:
1379: CURSOR c_combine_schedule(l_qp_list_header_id NUMBER, l_order_line_id NUMBER) IS
1380: SELECT offer_id, combine_schedule_yn, apply_discount_flag, group_no, volume_track_type, pbh_line_id
1381: FROM ozf_order_group_prod
1382: WHERE qp_list_header_id = l_qp_list_header_id
1383: AND order_line_id = l_order_line_id
1384: AND indirect_flag = DECODE(p_source_code, 'OM', 'O', 'IS', 'R');
1385:

Line 1549: FROM ozf_order_group_prod

1545: AND offer_id = p_offer_id;
1546:
1547: CURSOR c_order_group_prod_id(p_offer_id NUMBER, p_line_id NUMBER, p_indirect_flag VARCHAR2) IS
1548: SELECT order_group_prod_id
1549: FROM ozf_order_group_prod
1550: WHERE order_line_id = p_line_id
1551: AND offer_id = p_offer_id
1552: AND indirect_flag = p_indirect_flag;
1553:

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

1691: IF (p_order_line_id = l_split_from_line_id) THEN
1692: -- This happens when SO is split, the first child split has the same line_id as the parent SO
1693: l_group_prod_order_line_id := l_split_from_line_id;
1694: ELSE
1695: -- For the second, third,...splits, the selected split records need to be created/updated in ozf_order_group_prod
1696: -- In the earlier version the l_split_from_line_id record of ozf_order_group_prod was updated with
1697: -- order_line_id = p_order_line_id
1698: -- resulting in losing the l_split_from_line_id record in ozf_order_group_prod.
1699: l_group_prod_order_line_id := p_order_line_id;

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

1692: -- This happens when SO is split, the first child split has the same line_id as the parent SO
1693: l_group_prod_order_line_id := l_split_from_line_id;
1694: ELSE
1695: -- For the second, third,...splits, the selected split records need to be created/updated in ozf_order_group_prod
1696: -- In the earlier version the l_split_from_line_id record of ozf_order_group_prod was updated with
1697: -- order_line_id = p_order_line_id
1698: -- resulting in losing the l_split_from_line_id record in ozf_order_group_prod.
1699: l_group_prod_order_line_id := p_order_line_id;
1700: END IF;

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

1694: ELSE
1695: -- For the second, third,...splits, the selected split records need to be created/updated in ozf_order_group_prod
1696: -- In the earlier version the l_split_from_line_id record of ozf_order_group_prod was updated with
1697: -- order_line_id = p_order_line_id
1698: -- resulting in losing the l_split_from_line_id record in ozf_order_group_prod.
1699: l_group_prod_order_line_id := p_order_line_id;
1700: END IF;
1701: END IF;
1702: END IF;

Line 1709: INSERT INTO ozf_order_group_prod

1705: FETCH c_order_group_prod_id INTO l_id;
1706: CLOSE c_order_group_prod_id;
1707:
1708: IF l_id IS NULL THEN
1709: INSERT INTO ozf_order_group_prod
1710: (
1711: order_group_prod_id
1712: ,creation_date
1713: ,created_by

Line 1732: ( ozf_order_group_prod_s.NEXTVAL

1728: ,include_volume_flag
1729: ,indirect_flag
1730: )
1731: VALUES
1732: ( ozf_order_group_prod_s.NEXTVAL
1733: ,SYSDATE
1734: ,FND_GLOBAL.user_id
1735: ,SYSDATE
1736: ,FND_GLOBAL.user_id

Line 1753: UPDATE ozf_order_group_prod

1749: ,l_include_volume
1750: ,l_indirect_flag
1751: );
1752: ELSE
1753: UPDATE ozf_order_group_prod
1754: SET last_update_date = SYSDATE,
1755: last_updated_by = FND_GLOBAL.user_id,
1756: last_update_login = FND_GLOBAL.conc_login_id,
1757: order_line_id = p_order_line_id,

Line 1938: UPDATE ozf_order_group_prod

1934: SAVEPOINT update_tracking_line;
1935:
1936: x_return_status := Fnd_Api.g_ret_sts_success;
1937:
1938: UPDATE ozf_order_group_prod
1939: SET order_line_id = p_resale_line_id,
1940: indirect_flag = 'R'
1941: WHERE qp_list_header_id = p_list_header_id
1942: AND order_line_id = p_interface_line_id