Parameters
| Name | Type | Mode |
|---|---|---|
| p_booking_item | integer | IN |
SUM(sp_booking_rates_breakdown.room) for one booking item = the REVENUE_CALC_TYPE = 1 basis (Gross Room) at pickup time. Summed per night without multiplying room_qty, matching fn_booking_rate_revenue and fn_booking_room_net_revenue.
Returns NULL when the item no longer exists or has no rate rows; callers fall back to rsv_pickup.room_charge.
| Name | Type | Mode |
|---|---|---|
| p_booking_item | integer | IN |