Query to get price list details in Oracle EBS

1SELECT qpa.product_attr_value inventory_item_id,
2       spl.list_header_id     price_list_id,
3       qplt.name              price_list_name,
4       spll.start_date_active start_date_active,
5       spll.end_date_active   end_date_active,
6       spll.last_update_date  last_update_date,
7       spll.operand           list_price
8  FROM qp_list_lines         spll,
9       qp_pricing_attributes qpa,
10       qp_list_headers_b     spl,
11       qp_list_headers_tl    qplt,
12       mtl_system_items_b    msi
13 WHERE     spll.list_header_id = spl.list_header_id
14       AND spl.list_header_id = qplt.list_header_id
15       AND spll.list_line_id = qpa.list_line_id
16       AND msi.inventory_item_id = TO_CHAR (qpa.product_attr_value)
17       AND qplt.language = USERENV ('lang')
18       AND qplt.name = :P_price_list_name
19       AND msi.segment1 = :p_item