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 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 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,