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_ATTRIBUTES

Line 167: INSERT INTO qp_price_book_attributes

163: --For each of the deleted price book lines also copy the product attributes
164: --(Item Categories) , which have line_det_id = -1, since without the
165: --product attributes these lines will not be shown on Hgrid
166: FORALL i IN l_new_deleted_line_id_tbl.FIRST..l_new_deleted_line_id_tbl.LAST
167: INSERT INTO qp_price_book_attributes
168: (price_book_attribute_id, price_book_line_det_id,
169: price_book_line_id, price_book_header_id,
170: pricing_prod_context, pricing_prod_attribute,
171: pricing_prod_attr_value_from, pricing_attr_value_to,

Line 175: SELECT qp_price_book_attributes_s.nextval, price_book_line_det_id,

171: pricing_prod_attr_value_from, pricing_attr_value_to,
172: comparison_operator_code, pricing_prod_attr_datatype,
173: attribute_type, creation_date, created_by, last_update_date,
174: last_updated_by, last_update_login)
175: SELECT qp_price_book_attributes_s.nextval, price_book_line_det_id,
176: l_new_deleted_line_id_tbl(i), p_delta_price_book_header_id,
177: pricing_prod_context, pricing_prod_attribute,
178: pricing_prod_attr_value_from, pricing_attr_value_to,
179: comparison_operator_code, pricing_prod_attr_datatype,

Line 182: FROM qp_price_book_attributes

178: pricing_prod_attr_value_from, pricing_attr_value_to,
179: comparison_operator_code, pricing_prod_attr_datatype,
180: attribute_type, sysdate, l_user_id, sysdate, l_user_id,
181: l_login_id
182: FROM qp_price_book_attributes
183: WHERE price_book_line_id = l_deleted_line_id_tbl(i)
184: AND price_book_line_det_id = -1;
185:
186: EXIT WHEN deleted_lines_cur%NOTFOUND;

Line 206: DELETE FROM qp_price_book_attributes

202: WHERE price_book_line_id = l_unchanged_line_id_tbl(i);
203:
204: --Delete the price book attributes
205: FORALL i IN l_unchanged_line_id_tbl.FIRST..l_unchanged_line_id_tbl.LAST
206: DELETE FROM qp_price_book_attributes
207: WHERE price_book_line_id = l_unchanged_line_id_tbl(i);
208:
209: --Delete the price book line details
210: FORALL i IN l_unchanged_line_id_tbl.FIRST..l_unchanged_line_id_tbl.LAST

Line 1233: --qp_price_book_attributes table. The line_detail_id will be -1 since these

1229:
1230: l_inv_org_id := fnd_profile.value('QP_ORGANIZATION_ID');
1231:
1232: --For each item(line) in the price book insert the parent categories into the
1233: --qp_price_book_attributes table. The line_detail_id will be -1 since these
1234: --attributes are at the price book line level and used for UI and get_catalog
1235: --purposes.
1236: OPEN pb_items_cur (p_price_book_header_id);
1237: LOOP

Line 1246: INSERT INTO qp_price_book_attributes

1242: FETCH pb_items_cur BULK COLLECT INTO l_line_id_tbl, l_item_number_tbl
1243: LIMIT rows;
1244:
1245: FORALL i IN l_line_id_tbl.FIRST..l_line_id_tbl.LAST
1246: INSERT INTO qp_price_book_attributes
1247: (price_book_attribute_id, price_book_line_det_id,
1248: price_book_line_id, price_book_header_id,
1249: pricing_prod_context, pricing_prod_attribute,
1250: comparison_operator_code, pricing_prod_attr_value_from,

Line 1255: SELECT qp_price_book_attributes_s.nextval, -1,

1251: pricing_attr_value_to, pricing_prod_attr_datatype,
1252: attribute_type, creation_date, created_by, last_update_date,
1253: last_updated_by, last_update_login
1254: )
1255: SELECT qp_price_book_attributes_s.nextval, -1,
1256: l_line_id_tbl(i), p_price_book_header_id,
1257: 'ITEM', 'PRICING_ATTRIBUTE2', --Item Category
1258: '=', category_id, null, 'N',
1259: 'PRODUCT', sysdate, l_user_id, sysdate,

Line 1355: INSERT INTO qp_price_book_attributes

1351:
1352: --Insert records into the price book attrs table from the line attrs temp
1353: --table for Price List Lines
1354: FORALL k IN l_line_index2_tbl.FIRST..l_line_index2_tbl.LAST
1355: INSERT INTO qp_price_book_attributes
1356: (price_book_attribute_id, price_book_line_det_id,
1357: price_book_line_id, price_book_header_id,
1358: pricing_prod_context, pricing_prod_attribute,
1359: comparison_operator_code, pricing_prod_attr_value_from,

Line 1364: SELECT qp_price_book_attributes_s.nextval, a.pb_line_det_id,

1360: pricing_attr_value_to, pricing_prod_attr_datatype,
1361: attribute_type, creation_date, created_by, last_update_date,
1362: last_updated_by, last_update_login
1363: )
1364: SELECT qp_price_book_attributes_s.nextval, a.pb_line_det_id,
1365: a.pb_line_id, a.price_book_header_id,
1366: a.context, a.attribute,
1367: a.comparison_operator_type_code, a.setup_value_from,
1368: a.setup_value_to, a.datatype, a.attribute_type,

Line 1866: DELETE FROM qp_price_book_attributes

1862:
1863: DELETE FROM qp_price_book_line_details
1864: WHERE price_book_header_id = l_overwrite_pb_header_id;
1865:
1866: DELETE FROM qp_price_book_attributes
1867: WHERE price_book_header_id = l_overwrite_pb_header_id;
1868:
1869: DELETE FROM qp_price_book_break_lines
1870: WHERE price_book_header_id = l_overwrite_pb_header_id;

Line 1950: DELETE FROM qp_price_book_attributes

1946:
1947: DELETE FROM qp_price_book_line_details
1948: WHERE price_book_header_id = l_corr_delta_pb_header_id;
1949:
1950: DELETE FROM qp_price_book_attributes
1951: WHERE price_book_header_id = l_corr_delta_pb_header_id;
1952:
1953: DELETE FROM qp_price_book_break_lines
1954: WHERE price_book_header_id = l_corr_delta_pb_header_id;