APPS.MST_RELEASE dependencies on FTE_VEHICLE_TYPES

Line 452: , fte_vehicle_types fvt

448: , mt.lane_id
449: , mt.service_level
450: from mst_plans mp
451: , mst_trips mt
452: , fte_vehicle_types fvt
453: where mt.plan_id = p_plan_id
454: and mt.plan_id = mp.plan_id
455: and mt.vehicle_type_id = fvt.vehicle_type_id (+)
456: and mt.continuous_move_id = p_load_tab(i)

Line 516: , fte_vehicle_types fvt

512: , mt.lane_id
513: , mt.service_level
514: from mst_plans mp
515: , mst_trips mt
516: , fte_vehicle_types fvt
517: where mt.plan_id = p_plan_id
518: and mt.plan_id = mp.plan_id
519: and mt.vehicle_type_id = fvt.vehicle_type_id (+)
520: and mt.trip_id = p_load_tab(i)

Line 747: , fte_vehicle_types fvt

743: , mt.lane_id
744: , mt.service_level
745: from mst_plans mp
746: , mst_trips mt
747: , fte_vehicle_types fvt
748: where mt.plan_id = p_plan_id
749: and mt.continuous_move_id = p_cm_id_of_trip
750: and mt.plan_id = mp.plan_id
751: and mt.vehicle_type_id = fvt.vehicle_type_id (+)

Line 845: , fte_vehicle_types fvt

841: from mst_delivery_legs mdl
842: , mst_delivery_legs mdl1
843: , mst_trips mt
844: , mst_plans mp
845: , fte_vehicle_types fvt
846: where mdl.plan_id = p_plan_id
847: and mdl.trip_id = p_trip_id
848: and mdl1.plan_id = mdl.plan_id
849: and mdl1.delivery_id = mdl.delivery_id

Line 3519: , fte_vehicle_types fvt

3515: , mt.lane_id
3516: , mt.service_level
3517: from mst_plans mp
3518: , mst_trips mt
3519: , fte_vehicle_types fvt
3520: where mt.plan_id = '||p_plan_id||'
3521: and mt.plan_id = mp.plan_id
3522: and mt.vehicle_type_id = fvt.vehicle_type_id (+) and ( '||l_where_clause||' ))';
3523:

Line 3594: , fte_vehicle_types fvt

3590: , mt.lane_id
3591: , mt.service_level
3592: from mst_plans mp
3593: , mst_trips mt
3594: , fte_vehicle_types fvt
3595: where mt.plan_id = p_plan_id
3596: and mt.plan_id = mp.plan_id
3597: and mt.vehicle_type_id = fvt.vehicle_type_id (+)
3598: );