Tables
Qp_list_headers_b
Qp_list_headers_b stores the header information for all lists. List types can, for example, Price Lists, Discount Lists or promotions.
Qp_list_lines
Qp_list_lines stores all LIST LINES to lists in Qp_list_headers_b. This table stores all types of list lines; Price list lines, all types of modifiers including price modifier list lines used to derive factors. The different types of the list lines are based on Lookup Type, ' List_line_type_code '.
qp_pricing_attributes
Qp_pricing_attributes stores product information and PRICING ATTRIBUTES. The Product_attribute and Product_attribute_value columns identify the PRODUCT or level in the item hierarchy, i.e item Co ntext at which the "price" or modifier is set. The Pricing_attribute_context, Pricing_attribute and Pricing_attr_value_from columns store the PRICING attributes the which F Urther define what is being priced. If The Pricing_attribute_context is VOLUME the PRICING attributes column stores the break unit ATTRIBUTE, e.g. item Quanti Ty and both the Pricing_attr_value_from and pricing_attr_value_to columns can be populated. The Product information is repeated to all pricing attributes. A is always created for the VOLUME context, which may or could not have an attribute defined.
RelationshipQp_list_headers_b <---list_header_id---> qp_list_lines
Qp_list_lines <---list_header_id,list_line_id---> qp_pricing_attributes
Qp_pricing_attributes <---product_attr_value <> to_char (MSI. INVENTORY_ITEM_ID)---> Mtl_system_items_b
Useful Queries [SQL] View Plain copy print? select * from qp_list_headers_b where list_header_id in (SELECT list_ header_id from qp_list_headers_tl where name = ' Corporate ');--Price List name select line.* from qp_list_lines line,qp_list_ headers_b header Where line. List_header_id = header. list_header_id and line.list_header_id in (Select list_header_id from QP_LIST_HEADERS_TL WHERE name = ' Corporate '); --price list name select * from qp_list_headers_b spl , QP_LIST_LINES SPLL , qp_pricing_attributes qpa &nbsP WHERE&NBSP;&NBSP;SPLL. List_header_id = spl. list_header_id And qpa. List_header_id = spl. list_header_id AND&NBSP;&NBSP;&NBSP;&NBSP;SPLL. List_line_id = qpa. list_line_id And qpa. list_header_id in (select list_header_id from qp_list_headers_tl where name = ' Corporate '); --price list name select qpa.* from qp_list_headers_b spl , QP_LIST_LINES SPLL , QP_PRICING_ATTRIBUTES QPA, MTL_SYSTEM_ITEMS_B MSI Where msi. organization_id = 244 and msi. inventory_item_id = 434257 AND spl. list_header_id = 164075 AND&NBSP;&NBSP;&NBSP;&NBSP;SPLL. List_header_id = spl. list_header_id And qpa. List_header_id = spl. list_header_id AND&NBSP;&NBSP;&NBSP;&NBSP;SPLL. List_line_id = qpa. list_line_id And qpa. Product_attribute_context =&nBSP; ' ITEM ' And qpa. product_attribute = ' PRICING_ATTRIBUTE1 ' And qpa. Product_attr_value = to_char (MSI. inventory_item_id) And qpa. Product_uom_code = msi. primary_uom_code And qpa. pricing_attribute_context is null And qpa. excluder_flag = ' N ' and qpa. pricing_phase_id =1;