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.QP_PRICE_BOOK_PVT dependencies on QP_PRICE_BOOK_LINES

Line 17: FROM qp_price_book_lines

13: IS
14: CURSOR unchanged_lines_cur(a_price_book_header_id NUMBER)
15: IS
16: SELECT price_book_line_id
17: FROM qp_price_book_lines
18: WHERE sync_action_code = 'N'
19: AND price_book_header_id = a_price_book_header_id;
20:
21: l_user_id NUMBER;

Line 40: FROM qp_price_book_lines a

36: a_delta_price_book_header_id NUMBER)
37: IS
38: SELECT a.price_book_line_id, a.item_number, a.product_uom_code,
39: a.list_price, a.net_price, a.line_status_code
40: FROM qp_price_book_lines a
41: WHERE a.price_book_header_id = a_full_price_book_header_id
42: AND NOT EXISTS (SELECT 'X'
43: FROM qp_price_book_lines b
44: WHERE b.price_book_header_id=a_delta_price_book_header_id

Line 43: FROM qp_price_book_lines b

39: a.list_price, a.net_price, a.line_status_code
40: FROM qp_price_book_lines a
41: WHERE a.price_book_header_id = a_full_price_book_header_id
42: AND NOT EXISTS (SELECT 'X'
43: FROM qp_price_book_lines b
44: WHERE b.price_book_header_id=a_delta_price_book_header_id
45: AND b.item_number = a.item_number
46: AND b.product_uom_code = a.product_uom_code)
47: ORDER BY a.price_book_line_id;

Line 58: FROM qp_price_book_lines a

54: SELECT price_book_line_det_id, price_book_line_id
55: FROM qp_price_book_line_details
56: WHERE price_book_header_id = a_full_price_book_header_id
57: AND price_book_line_id IN (SELECT a.price_book_line_id
58: FROM qp_price_book_lines a
59: WHERE a.price_book_header_id =
60: a_full_price_book_header_id
61: AND NOT EXISTS
62: (SELECT 'X'

Line 63: FROM qp_price_book_lines b

59: WHERE a.price_book_header_id =
60: a_full_price_book_header_id
61: AND NOT EXISTS
62: (SELECT 'X'
63: FROM qp_price_book_lines b
64: WHERE b.price_book_header_id =
65: a_delta_price_book_header_id
66: AND b.item_number = a.item_number
67: AND b.product_uom_code =

Line 93: UPDATE qp_price_book_lines a

89: END;
90:
91: --Mark those delta price book lines with 'N' (not changed) that have not
92: --changed wrt to previous full price book
93: UPDATE qp_price_book_lines a
94: SET a.sync_action_code = 'N' -- unchanged lines will be removed from delta
95: WHERE a.price_book_header_id = p_delta_price_book_header_id
96: AND EXISTS (SELECT 'X'
97: FROM qp_price_book_lines b

Line 97: FROM qp_price_book_lines b

93: UPDATE qp_price_book_lines a
94: SET a.sync_action_code = 'N' -- unchanged lines will be removed from delta
95: WHERE a.price_book_header_id = p_delta_price_book_header_id
96: AND EXISTS (SELECT 'X'
97: FROM qp_price_book_lines b
98: WHERE b.price_book_header_id = l_full_price_book_header_id
99: AND b.item_number = a.item_number
100: AND b.product_uom_code = a.product_uom_code
101: AND nvl(b.list_price, 0) = nvl(a.list_price, 0)

Line 104: UPDATE qp_price_book_lines a

100: AND b.product_uom_code = a.product_uom_code
101: AND nvl(b.list_price, 0) = nvl(a.list_price, 0)
102: AND nvl(b.net_price, 0) = nvl(a.net_price, 0));
103:
104: UPDATE qp_price_book_lines a
105: SET a.sync_action_code = 'A' --Add
106: WHERE a.price_book_header_id = p_delta_price_book_header_id
107: AND NOT EXISTS (SELECT 'X'
108: FROM qp_price_book_lines b

Line 108: FROM qp_price_book_lines b

104: UPDATE qp_price_book_lines a
105: SET a.sync_action_code = 'A' --Add
106: WHERE a.price_book_header_id = p_delta_price_book_header_id
107: AND NOT EXISTS (SELECT 'X'
108: FROM qp_price_book_lines b
109: WHERE b.price_book_header_id = l_full_price_book_header_id
110: AND b.item_number = a.item_number
111: AND b.product_uom_code = a.product_uom_code);
112:

Line 113: UPDATE qp_price_book_lines a

109: WHERE b.price_book_header_id = l_full_price_book_header_id
110: AND b.item_number = a.item_number
111: AND b.product_uom_code = a.product_uom_code);
112:
113: UPDATE qp_price_book_lines a
114: SET sync_action_code = 'R' --Replace
115: WHERE price_book_header_id = p_delta_price_book_header_id
116: AND EXISTS (SELECT 'X'
117: FROM qp_price_book_lines b

Line 117: FROM qp_price_book_lines b

113: UPDATE qp_price_book_lines a
114: SET sync_action_code = 'R' --Replace
115: WHERE price_book_header_id = p_delta_price_book_header_id
116: AND EXISTS (SELECT 'X'
117: FROM qp_price_book_lines b
118: WHERE b.price_book_header_id = l_full_price_book_header_id
119: AND b.item_number = a.item_number
120: AND b.product_uom_code = a.product_uom_code
121: AND (nvl(b.list_price, 0) <> nvl(a.list_price, 0) OR

Line 144: INSERT INTO qp_price_book_lines

140:
141: --For each record in any of the bulk collection returned by the
142: --deleted_lines_cur cursor
143: FORALL i IN l_item_number_tbl.FIRST..l_item_number_tbl.LAST
144: INSERT INTO qp_price_book_lines
145: (price_book_line_id, price_book_header_id,
146: item_number,
147: product_uom_code,
148: list_price,

Line 153: VALUES (qp_price_book_lines_s.nextval, p_delta_price_book_header_id,

149: net_price,
150: sync_action_code, line_status_code, creation_date,
151: created_by, last_update_date, last_updated_by,
152: last_update_login)
153: VALUES (qp_price_book_lines_s.nextval, p_delta_price_book_header_id,
154: l_item_number_tbl(i),
155: l_uom_code_tbl(i),
156: l_list_price_tbl(i),
157: l_net_price_tbl(i),

Line 216: DELETE FROM qp_price_book_lines

212: WHERE price_book_line_id = l_unchanged_line_id_tbl(i);
213:
214: --Delete the price book lines
215: FORALL i IN l_unchanged_line_id_tbl.FIRST..l_unchanged_line_id_tbl.LAST
216: DELETE FROM qp_price_book_lines
217: WHERE price_book_line_id = l_unchanged_line_id_tbl(i);
218:
219: --Delete the price book line level messages
220: FORALL i IN l_unchanged_line_id_tbl.FIRST..l_unchanged_line_id_tbl.LAST

Line 323: FROM qp_price_book_lines

319: 'N', --validated_flag
320: null, --price_request_code
321: null, --usage_pricing_type
322: item_number
323: FROM qp_price_book_lines
324: WHERE price_book_header_id = a_price_book_header_id
325: ORDER BY price_book_line_id;
326:
327: l_attrs_line_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 444: FROM qp_price_book_lines

440:
441: CURSOR pb_items_cur(a_price_book_header_id NUMBER)
442: IS
443: SELECT price_book_line_id, item_number --inventory_item_id
444: FROM qp_price_book_lines
445: WHERE price_book_header_id = a_price_book_header_id;
446:
447: l_inv_org_id NUMBER;
448: l_net_price_tbl NUMBER_TYPE;

Line 526: FROM qp_price_book_lines

522:
523: BEGIN
524: SELECT 1
525: INTO l_pb_line_count
526: FROM qp_price_book_lines
527: WHERE price_book_header_id = p_price_book_header_id
528: AND rownum = 1;
529: EXCEPTION
530: WHEN OTHERS THEN

Line 1197: UPDATE qp_price_book_lines

1193:
1194: --Update the list and net price in the price book lines table with the values
1195: --calculated by the engine that are in the lines temp table
1196: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
1197: UPDATE qp_price_book_lines
1198: SET list_price = l_list_price_tbl(i),
1199: net_price = l_net_price_tbl(i)
1200: WHERE price_book_line_id = l_line_id_tbl(i);
1201:

Line 1675: FROM qp_price_book_lines

1671:
1672: CURSOR pb_lines_cur
1673: IS
1674: SELECT price_book_line_id, list_price
1675: FROM qp_price_book_lines
1676: WHERE price_book_header_id = p_price_book_header_id
1677: ORDER BY price_book_line_id;
1678:
1679: l_old_input_header_id NUMBER;

Line 1860: DELETE FROM qp_price_book_lines

1856:
1857: DELETE FROM qp_price_book_headers_tl
1858: WHERE price_book_header_id = l_overwrite_pb_header_id;
1859:
1860: DELETE FROM qp_price_book_lines
1861: WHERE price_book_header_id = l_overwrite_pb_header_id;
1862:
1863: DELETE FROM qp_price_book_line_details
1864: WHERE price_book_header_id = l_overwrite_pb_header_id;

Line 1944: DELETE FROM qp_price_book_lines

1940:
1941: DELETE FROM qp_price_book_headers_tl
1942: WHERE price_book_header_id = l_corr_delta_pb_header_id;
1943:
1944: DELETE FROM qp_price_book_lines
1945: WHERE price_book_header_id = l_corr_delta_pb_header_id;
1946:
1947: DELETE FROM qp_price_book_line_details
1948: WHERE price_book_header_id = l_corr_delta_pb_header_id;

Line 2143: INSERT INTO qp_price_book_lines

2139: LIMIT rows;
2140:
2141: --dbms_output.put_line(' item2 tbl count '||l_item2_tbl.count);
2142: FORALL j IN l_item2_tbl.FIRST..l_item2_tbl.LAST
2143: INSERT INTO qp_price_book_lines
2144: (price_book_line_id,
2145: price_book_header_id,
2146: item_number,
2147: product_uom_code,

Line 2156: (qp_price_book_lines_s.nextval,

2152: last_updated_by,
2153: last_update_login
2154: )
2155: VALUES
2156: (qp_price_book_lines_s.nextval,
2157: l_publish_price_book_header_id,
2158: l_item2_tbl(j),
2159: l_uom_tbl(j),
2160: 'R',

Line 2198: INSERT INTO qp_price_book_lines

2194: FETCH item_uom_cur BULK COLLECT INTO l_item2_tbl, l_uom_tbl
2195: LIMIT rows;
2196:
2197: FORALL j IN l_item2_tbl.FIRST..l_item2_tbl.LAST
2198: INSERT INTO qp_price_book_lines
2199: (price_book_line_id,
2200: price_book_header_id,
2201: item_number,
2202: product_uom_code,

Line 2211: (qp_price_book_lines_s.nextval,

2207: last_updated_by,
2208: last_update_login
2209: )
2210: VALUES
2211: (qp_price_book_lines_s.nextval,
2212: l_publish_price_book_header_id,
2213: l_item2_tbl(j),
2214: l_uom_tbl(j),
2215: 'R',

Line 2255: INSERT INTO qp_price_book_lines

2251: FETCH item_uom_cur BULK COLLECT INTO l_item2_tbl, l_uom_tbl
2252: LIMIT rows;
2253:
2254: FORALL j IN l_item2_tbl.FIRST..l_item2_tbl.LAST
2255: INSERT INTO qp_price_book_lines
2256: (price_book_line_id,
2257: price_book_header_id,
2258: item_number,
2259: product_uom_code,

Line 2268: (qp_price_book_lines_s.nextval,

2264: last_updated_by,
2265: last_update_login
2266: )
2267: VALUES
2268: (qp_price_book_lines_s.nextval,
2269: l_publish_price_book_header_id,
2270: l_item2_tbl(j),
2271: l_uom_tbl(j),
2272: 'R',

Line 2320: INSERT INTO qp_price_book_lines

2316: FETCH item_uom_cur BULK COLLECT INTO l_item2_tbl, l_uom_tbl
2317: LIMIT rows;
2318:
2319: FORALL j IN l_item2_tbl.FIRST..l_item2_tbl.LAST
2320: INSERT INTO qp_price_book_lines
2321: (price_book_line_id,
2322: price_book_header_id,
2323: item_number,
2324: product_uom_code,

Line 2333: (qp_price_book_lines_s.nextval,

2329: last_updated_by,
2330: last_update_login
2331: )
2332: VALUES
2333: (qp_price_book_lines_s.nextval,
2334: l_publish_price_book_header_id,
2335: l_item2_tbl(j),
2336: l_uom_tbl(j),
2337: 'R',

Line 2514: UPDATE qp_price_book_lines

2510: --Bulk update the net price on the summary price book line to the
2511: --the calculated running net price. This is to ensure that the summary
2512: --net price includes any freight and special charges.
2513: FORALL m IN l_line_id_tbl2.FIRST..l_line_id_tbl2.LAST
2514: UPDATE qp_price_book_lines
2515: SET net_price = l_net_price_tbl(m)
2516: WHERE price_book_line_id = l_line_id_tbl2(m);
2517:
2518: EXIT WHEN pb_lines_cur%NOTFOUND;