Oracle EBS Advanced Pricing Tables. ____oracle

Source: Internet
Author: User
Tags modifier spl
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; 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.