Query to get price list details in Oracle EBS

Query to get price list details in Oracle EBS
oracle ebs price list tables
Oracle apps price list query
oracle apps price list tables

SELECT qpa.product_attr_value inventory_item_id,
       spl.list_header_id     price_list_id,
       qplt.name              price_list_name,
       spll.start_date_active start_date_active,
       spll.end_date_active   end_date_active,
       spll.last_update_date  last_update_date,
       spll.operand           list_price
  FROM qp_list_lines         spll,
       qp_pricing_attributes qpa,
       qp_list_headers_b     spl,
       qp_list_headers_tl    qplt,
       mtl_system_items_b    msi
 WHERE     spll.list_header_id = spl.list_header_id
       AND spl.list_header_id = qplt.list_header_id
       AND spll.list_line_id = qpa.list_line_id
       AND msi.inventory_item_id = TO_CHAR (qpa.product_attr_value)
       AND qplt.language = USERENV ('lang')
       AND qplt.name = :P_price_list_name
       AND msi.segment1 = :p_item

Related posts:

• Sales order line status query in Oracle apps
• Query to get price list details in Oracle EBS
• Query to find all APIs of Oracle Apps modules
• Oracle R12 shipping status query
• Query to get customer tax registration details in R12
• Query to get Sales order and lines details in Oracle Apps
• Query to find serial number material transactions details
• Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets
• Query to find Sales Orders that are shipped but not invoiced
• Query to get Customer Bank Account Details
• AR Invoice grouping rule from RA_INTERFACE_LINES_ALL
• Query to find shipset and fulfilment set

Upload your own post and refer it anywhere anytime: