DBA Data[Home] [Help]

APPS.FTE_LANE_SEARCH dependencies on FTE_LANE_GROUP_COMPONENTS

Line 270: select 1 from fte_lane_group_components c, fte_lane_vehicles l

266: and carrier_id = p_carrier_id
267: and nvl(effective_start_date, nvl(p_date, sysdate)) <= nvl(p_date, sysdate)
268: and nvl(effective_end_date, nvl(p_date, sysdate)) >= nvl(p_date, sysdate)
269: UNION
270: select 1 from fte_lane_group_components c, fte_lane_vehicles l
271: where l.quantity = 0
272: and c.lane_group_id = l.lane_group_id
273: and c.origin_id = p_origin_id
274: and c.destination_id = p_dest_id