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_DELIVERIES

Line 1305: , mst_deliveries md

1301: , md.latest_acceptable_date
1302: , md.supplier_id
1303: , hzr.object_id
1304: from mst_release_temp_gt mrt
1305: , mst_deliveries md
1306: , mst_delivery_legs mdl
1307: , mst_plans mp
1308: , hz_relationships hzr
1309: where mrt.release_id = p_release_id

Line 2342: procedure update_mst_deliveries (x_return_status out nocopy varchar2

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
2345: , p_release_id in pls_integer
2346: , p_error_found in pls_integer) is

Line 2363: print_info(g_log_flow_of_control,'update_mst_deliveries for group '||p_group_id||' : Program started');

2359:
2360: l_error_found pls_integer := p_error_found;
2361: l_plan_id number := p_plan_id;
2362: begin
2363: print_info(g_log_flow_of_control,'update_mst_deliveries for group '||p_group_id||' : Program started');
2364: if l_error_found = 0 then
2365: open cur_deliveries(p_release_id, p_group_id);
2366: fetch cur_deliveries bulk collect into l_delivery_id_tab, l_planned_flag_tab;
2367: close cur_deliveries;

Line 2371: update mst_deliveries -- remember l_error_found = 0 => successful and l_error_found = 1 => unsuccessful

2367: close cur_deliveries;
2368:
2369: if nvl(l_delivery_id_tab.last,0) > 0 then
2370: forall i in 1..l_delivery_id_tab.last
2371: update mst_deliveries -- remember l_error_found = 0 => successful and l_error_found = 1 => unsuccessful
2372: set planned_flag = decode(l_planned_flag_tab(i),1,1,2)
2373: , preserve_grouping_flag = decode(l_planned_flag_tab(i),1,null,2,1,2)
2374: , known_te_firm_status = l_planned_flag_tab(i)
2375: where plan_id = l_plan_id

Line 2381: print_info(g_log_flow_of_control,'update_mst_deliveries for group '||p_group_id||' : Program ended');

2377: end if;
2378: end if;
2379:
2380: x_return_status := fnd_api.g_ret_sts_success;
2381: print_info(g_log_flow_of_control,'update_mst_deliveries for group '||p_group_id||' : Program ended');
2382: exception
2383: when others then
2384: x_return_status := fnd_api.g_ret_sts_unexp_error;
2385: print_info(g_log_flow_of_control,'update_mst_deliveries : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);

Line 2385: print_info(g_log_flow_of_control,'update_mst_deliveries : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);

2381: print_info(g_log_flow_of_control,'update_mst_deliveries for group '||p_group_id||' : Program ended');
2382: exception
2383: when others then
2384: x_return_status := fnd_api.g_ret_sts_unexp_error;
2385: print_info(g_log_flow_of_control,'update_mst_deliveries : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
2386: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
2387: end update_mst_deliveries;
2388:
2389: procedure update_sr_ids_in_mt (x_return_status out nocopy varchar2

Line 2387: end update_mst_deliveries;

2383: when others then
2384: x_return_status := fnd_api.g_ret_sts_unexp_error;
2385: print_info(g_log_flow_of_control,'update_mst_deliveries : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
2386: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
2387: end update_mst_deliveries;
2388:
2389: procedure update_sr_ids_in_mt (x_return_status out nocopy varchar2
2390: , p_group_id in pls_integer
2391: , p_plan_id in number

Line 2467: update mst_deliveries

2463: close cur_deliveries;
2464:
2465: if nvl(l_delivery_id_tab.last,0) > 0 then
2466: forall i in 1..l_delivery_id_tab.last
2467: update mst_deliveries
2468: set sr_delivery_id = l_sr_delivery_id_tab(i)
2469: where plan_id = l_plan_id
2470: and delivery_id = l_delivery_id_tab(i);
2471: end if;

Line 2594: update_mst_deliveries (l_return_status, p_group_tab(i), p_plan_id, p_release_id, 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
2594: update_mst_deliveries (l_return_status, p_group_tab(i), p_plan_id, p_release_id, l_error_found);
2595: if l_return_status <> fnd_api.g_ret_sts_success then
2596: raise l_error_from_called_procedure;
2597: else
2598: update_sr_ids_in_mt (l_return_status, p_group_tab(i), p_plan_id, p_release_id, l_error_found);

Line 3402: l_where_clause := l_where_clause || ' and ' || ' exists (select 1 from mst_deliveries md, mst_delivery_legs mdl';

3398: -- CARRIER (=, !=)
3399: l_where_clause := l_where_clause || ' and ' || ' mt.carrier_id ' || get_cond(l_condition) || ' ' || nvl(l_from_number_value,0);
3400: elsif (l_attribute_code = AREL_SUPPLIER_CODE) then
3401: -- SUPPLIER (=, !=)
3402: l_where_clause := l_where_clause || ' and ' || ' exists (select 1 from mst_deliveries md, mst_delivery_legs mdl';
3403: l_where_clause := l_where_clause || ' where mt.plan_id = mdl.plan_id and mt.trip_id = mdl.trip_id and mdl.plan_id = md.plan_id';
3404: l_where_clause := l_where_clause || ' and mdl.delivery_id = md.delivery_id and md.supplier_id ' || get_cond(l_condition);
3405: l_where_clause := l_where_clause || ' ' || nvl(l_from_number_value,0) || ')';
3406: elsif (l_attribute_code = AREL_CUSTOMER_CODE) then

Line 3408: l_where_clause := l_where_clause || ' and ' || ' exists (select 1 from mst_deliveries md, mst_delivery_legs mdl';

3404: l_where_clause := l_where_clause || ' and mdl.delivery_id = md.delivery_id and md.supplier_id ' || get_cond(l_condition);
3405: l_where_clause := l_where_clause || ' ' || nvl(l_from_number_value,0) || ')';
3406: elsif (l_attribute_code = AREL_CUSTOMER_CODE) then
3407: -- CUSTOMER (=, !=)
3408: l_where_clause := l_where_clause || ' and ' || ' exists (select 1 from mst_deliveries md, mst_delivery_legs mdl';
3409: l_where_clause := l_where_clause || ' where mt.plan_id = mdl.plan_id and mt.trip_id = mdl.trip_id and mdl.plan_id = md.plan_id';
3410: l_where_clause := l_where_clause || ' and mdl.delivery_id = md.delivery_id and md.customer_id ' || get_cond(l_condition);
3411: l_where_clause := l_where_clause || ' ' || nvl(l_from_number_value,0) || ')';
3412: elsif (l_attribute_code = AREL_MODE_CODE) then