Here is the sample SQL Query to fetch the Price List Lines for the Items. Please modify the query as per the requirements.
SELECT h.name AS price_list,
l.list_line_id,
l.product_id,
l.uom_code,
l.start_date_active,
l.end_date_active,
l.line_type_code
FROM qp_list_headers_b h
JOIN qp_list_lines_b l ON h.list_header_id = l.list_header_id
WHERE h.name = 'Standard Price List'
AND l.list_line_type_code = 'PRICE';
