SQL Query to fetch the Active Price Lists

 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);