APPS.MST_AGG_PKG dependencies on MST_PLANS

Line 57: from mst_plans

53: l_count number;
54: begin
55: select total_orders
56: into l_count
57: from mst_plans
58: where plan_id = p_plan_id;
59: return l_count;
60: EXCEPTION
61: WHEN NO_DATA_FOUND THEN

Line 71: from mst_plans

67: l_count number;
68: begin
69: select decode(p_mode_of_transport, 'TRUCK', total_tl_orders, 'LTL', total_ltl_orders, 'PARCEL', total_parcel_orders, 0)
70: into l_count
71: from mst_plans
72: where plan_id = p_plan_id;
73: return l_count;
74: EXCEPTION
75: WHEN NO_DATA_FOUND THEN

Line 85: from mst_plans

81: l_count number;
82: begin
83: select total_cm_orders
84: into l_count
85: from mst_plans
86: where plan_id = p_plan_id;
87: return l_count;
88: EXCEPTION
89: WHEN NO_DATA_FOUND THEN

Line 541: from mst_plans

537: l_total_savings number;
538: begin
539: select total_cm_cost
540: into l_total_cm_cost
541: from mst_plans
542: where plan_id = p_plan_id;
543:
544: select
545: sum(total_basic_transport_cost + total_stop_cost

Line 591: -- number of orders, total costs can be fetched directly from MST_PLANS

587: /* Continuous Move Details */
588: -- open issues
589:
590: /* All Orders */
591: -- number of orders, total costs can be fetched directly from MST_PLANS
592: /* Order Details */
593: function get_order_weight(p_source_code in varchar2,
594: p_source_header_number in varchar2)
595: return number is