Oracle EBS Advanced Pricing Tables. ____oracle

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;