/* Formatted on 9/11/2023 12:58:38 PM (QP5 v5.396) */
  SELECT crv.CURVE_ALLEGRO_PRICEINDEX, CV.*, SYSDATE
    FROM MARKET_DATA.CURVE_VALUE CV, MARKET_DATA.CURVE crv
    where CV.CURVE_ID = crv.CURVE_ID
ORDER BY CV.CV_PRICE_DATE DESC, CV.CURVE_ID, CV.CV_DELIV_DATE;

select * from MARKET_DATA.CURVE;

/* Formatted on 9/11/2023 1:09:11 PM (QP5 v5.396) */
  SELECT crv.CURVE_NAME, c_DS.*
    FROM MARKET_DATA.CURVE_DATASET c_DS, MARKET_DATA.CURVE crv
   WHERE c_DS.CURVE_ID = crv.CURVE_ID
ORDER BY c_DS.CURVE_DATASET_DATE DESC;

select * from MARKET_DATA.CURVE_XREF order by curve_id;

