DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PVT dependencies on QP_PRICE_BOOK_ATTRIBUTES_S

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 1274: SELECT qp_price_book_attributes_s.nextval, -1,

1270: pricing_attr_value_to, pricing_prod_attr_datatype,
1271: attribute_type, creation_date, created_by, last_update_date,
1272: last_updated_by, last_update_login
1273: )
1274: SELECT qp_price_book_attributes_s.nextval, -1,
1275: l_line_id_tbl(i), p_price_book_header_id,
1276: 'ITEM', 'PRICING_ATTRIBUTE2', --Item Category
1277: '=', category_id, null, 'N',
1278: 'PRODUCT', sysdate, l_user_id, sysdate,

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

1380: pricing_attr_value_to, pricing_prod_attr_datatype,
1381: attribute_type, creation_date, created_by, last_update_date,
1382: last_updated_by, last_update_login
1383: )
1384: SELECT qp_price_book_attributes_s.nextval, a.pb_line_det_id,
1385: a.pb_line_id, a.price_book_header_id,
1386: a.context, a.attribute,
1387: a.comparison_operator_type_code, a.setup_value_from,
1388: a.setup_value_to, a.datatype, a.attribute_type,