Price list tables in oracle apps r12

Price list tables in oracle apps r12

In this post, We will be discuss about Price list tables in oracle apps r12. Price List is uses in the Oracle Sales Order. In Price List , we define the Finished Good Item Selling Price. Based on this Item Prices , Sales Order booking amount Calculates for the  Oracle customers. Here in this Post, We will be discuss about Price list tables in oracle apps r12.

 

 

2 Important Tables of Price list tables in oracle apps r12

1.qp_list_headers_tl

2.qp_list_lines

 

 

 SQL Query to Extract the Price list tables in oracle apps r12

select qph.name  "Price List Name",
, msi.segment1  "Inventory Item Name",
,qpl.operand  
,qpl.product_precedence
from qp_list_headers qph,
apps.qp_list_lines_v qpl,
inv.mtl_system_items_b msi
 where qph.list_header_id = qpl.list_header_id
 and msi.ORGANIZATION_ID =:P_ORG_ID
and msi.segment1 =:P_ITEM_NUMBER
and TO_CHAR(qpl.product_attr_value) = to_char(msi.inventory_item_id)