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 443: FROM qp_price_book_lines

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

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 1216: UPDATE qp_price_book_lines

1212:
1213: --Update the list and net price in the price book lines table with the values
1214: --calculated by the engine that are in the lines temp table
1215: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
1216: UPDATE qp_price_book_lines
1217: SET list_price = l_list_price_tbl(i),
1218: net_price = l_net_price_tbl(i)
1219: WHERE price_book_line_id = l_line_id_tbl(i);
1220:

Line 1656: FROM qp_price_book_lines

1652:
1653: CURSOR pb_lines_cur
1654: IS
1655: SELECT price_book_line_id, list_price
1656: FROM qp_price_book_lines
1657: WHERE price_book_header_id = p_price_book_header_id
1658: ORDER BY price_book_line_id;
1659:
1660: l_old_input_header_id NUMBER;

Line 1841: DELETE FROM qp_price_book_lines

1837:
1838: DELETE FROM qp_price_book_headers_tl
1839: WHERE price_book_header_id = l_overwrite_pb_header_id;
1840:
1841: DELETE FROM qp_price_book_lines
1842: WHERE price_book_header_id = l_overwrite_pb_header_id;
1843:
1844: DELETE FROM qp_price_book_line_details
1845: WHERE price_book_header_id = l_overwrite_pb_header_id;

Line 1925: DELETE FROM qp_price_book_lines

1921:
1922: DELETE FROM qp_price_book_headers_tl
1923: WHERE price_book_header_id = l_corr_delta_pb_header_id;
1924:
1925: DELETE FROM qp_price_book_lines
1926: WHERE price_book_header_id = l_corr_delta_pb_header_id;
1927:
1928: DELETE FROM qp_price_book_line_details
1929: WHERE price_book_header_id = l_corr_delta_pb_header_id;

Line 2123: INSERT INTO qp_price_book_lines

2119: LIMIT rows;
2120:
2121: --dbms_output.put_line(' item2 tbl count '||l_item2_tbl.count);
2122: FORALL j IN l_item2_tbl.FIRST..l_item2_tbl.LAST
2123: INSERT INTO qp_price_book_lines
2124: (price_book_line_id,
2125: price_book_header_id,
2126: item_number,
2127: product_uom_code,

Line 2136: (qp_price_book_lines_s.nextval,

2132: last_updated_by,
2133: last_update_login
2134: )
2135: VALUES
2136: (qp_price_book_lines_s.nextval,
2137: l_publish_price_book_header_id,
2138: l_item2_tbl(j),
2139: l_uom_tbl(j),
2140: 'R',

Line 2179: INSERT INTO qp_price_book_lines

2175: FETCH item_uom_cur BULK COLLECT INTO l_item2_tbl, l_uom_tbl
2176: LIMIT rows;
2177:
2178: FORALL j IN l_item2_tbl.FIRST..l_item2_tbl.LAST
2179: INSERT INTO qp_price_book_lines
2180: (price_book_line_id,
2181: price_book_header_id,
2182: item_number,
2183: product_uom_code,

Line 2192: (qp_price_book_lines_s.nextval,

2188: last_updated_by,
2189: last_update_login
2190: )
2191: VALUES
2192: (qp_price_book_lines_s.nextval,
2193: l_publish_price_book_header_id,
2194: l_item2_tbl(j),
2195: l_uom_tbl(j),
2196: 'R',

Line 2234: INSERT INTO qp_price_book_lines

2230: FETCH item_uom_cur BULK COLLECT INTO l_item2_tbl, l_uom_tbl
2231: LIMIT rows;
2232:
2233: FORALL j IN l_item2_tbl.FIRST..l_item2_tbl.LAST
2234: INSERT INTO qp_price_book_lines
2235: (price_book_line_id,
2236: price_book_header_id,
2237: item_number,
2238: product_uom_code,

Line 2247: (qp_price_book_lines_s.nextval,

2243: last_updated_by,
2244: last_update_login
2245: )
2246: VALUES
2247: (qp_price_book_lines_s.nextval,
2248: l_publish_price_book_header_id,
2249: l_item2_tbl(j),
2250: l_uom_tbl(j),
2251: 'R',

Line 2300: INSERT INTO qp_price_book_lines

2296: FETCH item_uom_cur BULK COLLECT INTO l_item2_tbl, l_uom_tbl
2297: LIMIT rows;
2298:
2299: FORALL j IN l_item2_tbl.FIRST..l_item2_tbl.LAST
2300: INSERT INTO qp_price_book_lines
2301: (price_book_line_id,
2302: price_book_header_id,
2303: item_number,
2304: product_uom_code,

Line 2313: (qp_price_book_lines_s.nextval,

2309: last_updated_by,
2310: last_update_login
2311: )
2312: VALUES
2313: (qp_price_book_lines_s.nextval,
2314: l_publish_price_book_header_id,
2315: l_item2_tbl(j),
2316: l_uom_tbl(j),
2317: 'R',

Line 2492: UPDATE qp_price_book_lines

2488: --Bulk update the net price on the summary price book line to the
2489: --the calculated running net price. This is to ensure that the summary
2490: --net price includes any freight and special charges.
2491: FORALL m IN l_line_id_tbl2.FIRST..l_line_id_tbl2.LAST
2492: UPDATE qp_price_book_lines
2493: SET net_price = l_net_price_tbl(m)
2494: WHERE price_book_line_id = l_line_id_tbl2(m);
2495:
2496: EXIT WHEN pb_lines_cur%NOTFOUND;