eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MST_RELEASE dependencies on MST_TRIPS

Line 451: , mst_trips mt

447: , mt.load_tender_status
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 (+)

Line 515: , mst_trips mt

511: , mt.load_tender_status
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 (+)

Line 746: , mst_trips mt

742: , mt.load_tender_status
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

Line 843: , mst_trips mt

839: , mt.lane_id
840: , mt.service_level
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

Line 2267: procedure update_mst_trips (x_return_status out nocopy varchar2

2263: when others then
2264: return 0;
2265: end get_statistics;
2266:
2267: procedure update_mst_trips (x_return_status out nocopy varchar2
2268: , p_group_id in pls_integer
2269: , p_plan_id in number
2270: , p_release_id in pls_integer
2271: , p_release_mode in number

Line 2291: print_info(g_log_flow_of_control,'update_mst_trips for group '||p_group_id||' : Program started');

2287: l_release_mode pls_integer := nvl(p_release_mode,2);
2288: l_plan_id number := p_plan_id;
2289: l_date date := p_date;
2290: begin
2291: print_info(g_log_flow_of_control,'update_mst_trips for group '||p_group_id||' : Program started');
2292:
2293: open cur_trips(p_release_id, p_group_id);
2294: fetch cur_trips bulk collect into l_trip_id_tab, l_planned_flag_tab;
2295: close cur_trips;

Line 2300: update mst_trips

2296:
2297: if nvl(l_trip_id_tab.last,0) > 0 then
2298: if p_error_found = 0 then -- group was successful
2299: forall i in 1..l_trip_id_tab.last
2300: update mst_trips
2301: set planned_flag = l_planned_flag_tab(i)
2302: , release_status = l_planned_flag_tab(i)
2303: , release_date = l_date
2304: , auto_release_flag = l_release_mode

Line 2317: update mst_trips

2313: g_cnt_deadhead_released := g_cnt_deadhead_released + get_statistics(p_release_id, p_plan_id, p_group_id, 'DEADHEAD');
2314:
2315: else -- group was not successful
2316: forall i in 1..l_trip_id_tab.last
2317: update mst_trips
2318: set release_status = 4
2319: , release_date = l_date -- datetime at start process, it is coming as parameter to this procedure
2320: , auto_release_flag = l_release_mode
2321: , selected_for_release = null

Line 2334: print_info(g_log_flow_of_control,'update_mst_trips for group '||p_group_id||' : Program ended');

2330: end if;
2331: end if;
2332:
2333: x_return_status := fnd_api.g_ret_sts_success;
2334: print_info(g_log_flow_of_control,'update_mst_trips for group '||p_group_id||' : Program ended');
2335: exception
2336: when others then
2337: x_return_status := fnd_api.g_ret_sts_unexp_error;
2338: print_info(g_log_flow_of_control,'update_mst_trips : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);

Line 2338: print_info(g_log_flow_of_control,'update_mst_trips : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);

2334: print_info(g_log_flow_of_control,'update_mst_trips for group '||p_group_id||' : Program ended');
2335: exception
2336: when others then
2337: x_return_status := fnd_api.g_ret_sts_unexp_error;
2338: print_info(g_log_flow_of_control,'update_mst_trips : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
2339: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
2340: end update_mst_trips;
2341:
2342: procedure update_mst_deliveries (x_return_status out nocopy varchar2

Line 2340: end update_mst_trips;

2336: when others then
2337: x_return_status := fnd_api.g_ret_sts_unexp_error;
2338: print_info(g_log_flow_of_control,'update_mst_trips : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
2339: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
2340: end update_mst_trips;
2341:
2342: procedure update_mst_deliveries (x_return_status out nocopy varchar2
2343: , p_group_id in pls_integer
2344: , p_plan_id in number

Line 2395: --cursor to retrieve the trips in a group to update mst_trips

2391: , p_plan_id in number
2392: , p_release_id in pls_integer
2393: , p_error_found in pls_integer) is
2394:
2395: --cursor to retrieve the trips in a group to update mst_trips
2396: cursor cur_trips (l_release_id in pls_integer, l_group_id in pls_integer)
2397: is
2398: select mrt.trip_id, wti.trip_id
2399: from mst_release_temp_gt mrt

Line 2420: update mst_trips

2416: close cur_trips;
2417:
2418: if nvl(l_trip_id_tab.last,0) > 0 then
2419: forall i in 1..l_trip_id_tab.last
2420: update mst_trips
2421: set sr_trip_id = l_sr_trip_id_tab(i)
2422: where plan_id = l_plan_id
2423: and trip_id = l_trip_id_tab(i);
2424: end if;

Line 2442: --cursor to retrieve the trips in a group to update mst_trips

2438: , p_plan_id in number
2439: , p_release_id in pls_integer
2440: , p_error_found in pls_integer) is
2441:
2442: --cursor to retrieve the trips in a group to update mst_trips
2443: cursor cur_deliveries (l_release_id in pls_integer, l_group_id in pls_integer)
2444: is
2445: select mrt.delivery_id, wndi.delivery_id
2446: from mst_release_temp_gt mrt

Line 2489: --cursor to retrieve the trips in a group to update mst_trips

2485: , p_plan_id in number
2486: , p_release_id in pls_integer
2487: , p_error_found in pls_integer) is
2488:
2489: --cursor to retrieve the trips in a group to update mst_trips
2490: cursor cur_delivery_details (l_release_id in pls_integer, l_group_id in pls_integer)
2491: is
2492: select mrt.delivery_detail_id, wddi.delivery_detail_id
2493: from mst_release_temp_gt mrt

Line 2589: update_mst_trips (l_return_status, p_group_tab(i), p_plan_id, p_release_id, p_release_mode, l_date, l_error_found);

2585: update_mst_cm_trips (l_return_status, p_group_tab(i), p_plan_id, p_release_id, p_release_mode, l_date, l_error_found);
2586: if l_return_status <> fnd_api.g_ret_sts_success then
2587: raise l_error_from_called_procedure;
2588: else
2589: update_mst_trips (l_return_status, p_group_tab(i), p_plan_id, p_release_id, p_release_mode, l_date, l_error_found);
2590: if l_return_status <> fnd_api.g_ret_sts_success then
2591: raise l_error_from_called_procedure;
2592: else
2593: if l_error_found = 0 then -- if successful only proceed

Line 3518: , mst_trips mt

3514: , mt.load_tender_status
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||' ))';

Line 3593: , mst_trips mt

3589: , mt.load_tender_status
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 (+)