Here is the sample SQL Query to fetch the Price Lists in Oracle fusion.
SELECT qlb.list_header_id, qlb.name, qlb.description, qlb.currency_code,qlb.*
FROM qp_list_headers_b qlb
WHERE qlb.list_type_code = 'PRL'
AND SYSDATE BETWEEN qlb.start_date_active AND NVL(qlb.end_date_active, SYSDATE);
