aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_sales_target_segment_name
Parameters
Name
Type
Mode
p_segment_type
text
IN
p_segment_id
integer
IN
Definition
SELECT CASE p_segment_type WHEN 'overall' THEN 'Overall' WHEN 'origin' THEN (SELECT name::text FROM public.origin WHERE id = p_segment_id) WHEN 'sales_staff' THEN (SELECT name::text FROM public.sales_staff WHERE id = p_segment_id) WHEN 'market' THEN (SELECT name::text FROM public.market WHERE id = p_segment_id) WHEN 'channel' THEN (SELECT name::text FROM public.channel WHERE id = p_segment_id) WHEN 'room_type' THEN (SELECT name::text FROM public.room_type WHERE id = p_segment_id) WHEN 'rate_plan' THEN (SELECT name::text FROM public.rate_plan WHERE id = p_segment_id) END