DBA Data[Home] [Help]

APPS.MST_RELEASE dependencies on MST_TRIP_STOPS

Line 1052: from mst_trip_stops mts

1048: from mst_delivery_legs mdl -- continuous_move_id is not being checked
1049: where mdl.plan_id = l_plan_id -- since it is not being populated without trip_id1
1050: and mdl.trip_id = l_trip_id)
1051: or med.location_id in (select mts.stop_location_id
1052: from mst_trip_stops mts
1053: where mts.plan_id = l_plan_id
1054: and mts.trip_id = l_trip_id));
1055:
1056: l_release_option number;

Line 1612: , mst_trip_stops mts

1608: , mts.pln_loading_end_time
1609: , mts.pln_unloading_start_time
1610: , mts.pln_unloading_end_time
1611: from mst_plans mp
1612: , mst_trip_stops mts
1613: , mst_release_temp_gt mrt
1614: where mrt.release_id = p_release_id
1615: and mrt.plan_id = mts.plan_id
1616: and mrt.trip_id = mts.trip_id