need a Query to get GL_DAILY_RATE for the expenditure_item_date

Hi ,

We have a requirement to build Logic is the quantity in the Expenditure details table needs to be multiplied with the exchange rate between transactional currency and Funding currency. The exchange rate should be of expenditure item date.

But the subquery returns ORA-01427: single-row subquery returns more than one row.

  ( SELECT (pxi1.quantity*gdr.conversion_rate) COST_FUNDING_CURRENCY

FROM  gl_daily_conversion_types typ

,   gl_daily_rates      gdr,

pa_expenditure_items_all pxi1

WHERE gdr.conversion_type = typ.conversion_type

AND  gdr.from_currency  < gdr.to_currency 

        AND gdr.conversion_date = pxi1.expenditure_item_date

        and pxi.expenditure_item_id=pxi1.expenditure_item_id