aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_booking_rate_revenue
Parameters
Name
Type
Mode
p_booking_item
integer
IN
Definition
SELECT SUM(r.room_rate)::public.t_money FROM ( SELECT br.charge_date, br.room_rate FROM public.booking_rates br WHERE br.booking_item = p_booking_item UNION ALL SELECT br.charge_date, br.room_rate FROM backup.booking_rates br WHERE br.booking_item = p_booking_item AND NOT EXISTS ( SELECT 1 FROM public.booking_rates active WHERE active.booking_item = br.booking_item AND active.charge_date = br.charge_date ) ) r;