[Home] [Help]
16: CURSOR c_ship_method
17: IS
18: SELECT ship_method,
19: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
20: FROM msc_interorg_ship_methods mism,
21: msc_regions_temp mrt
22: WHERE plan_id = -1
23: AND from_location_id = p_from_location_id
24: AND sr_instance_id = p_from_instance_id
34: BEGIN
35: -- bug 2958287
36: SELECT ship_method
37: INTO l_ship_method
38: FROM msc_interorg_ship_methods
39: WHERE plan_id = -1
40: AND from_location_id = p_from_location_id
41: AND sr_instance_id = p_from_instance_id
42: AND to_location_id = p_to_location_id
51: --- BUG 21130222: chnage sql into cursor to select right ship method
52: --- THE sql below selects the wrong ship method
53: /*SELECT ship_method
54: INTO l_ship_method
55: FROM msc_interorg_ship_methods mism,
56: msc_regions_temp mrt
57: WHERE plan_id = -1
58: AND from_location_id = p_from_location_id
59: AND sr_instance_id = p_from_instance_id
89: l_level NUMBER;
90: CURSOR c_lead_time is
91: SELECT intransit_time,
92: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
93: FROM msc_interorg_ship_methods,
94: msc_regions_temp mrt
95: WHERE plan_id = -1
96: AND from_location_id = p_from_location_id
97: AND sr_instance_id = p_from_instance_id
107: BEGIN
108: -- bug 2958287
109: SELECT intransit_time
110: INTO l_intransit_time
111: FROM msc_interorg_ship_methods
112: WHERE plan_id = -1
113: AND from_location_id = p_from_location_id
114: AND sr_instance_id = p_from_instance_id
115: AND to_location_id = p_to_location_id
124:
125: /*
126: SELECT intransit_time
127: INTO l_intransit_time
128: FROM msc_interorg_ship_methods,
129: msc_regions_temp mrt
130: WHERE plan_id = -1
131: AND from_location_id = p_from_location_id
132: AND sr_instance_id = p_from_instance_id
170:
171: -- bug 2958287
172: select ship_method
173: into l_ship_method
174: from msc_interorg_ship_methods
175: where plan_id = -1
176: and from_organization_id = p_from_org_id
177: and sr_instance_id = p_from_org_instance_id
178: and to_organization_id = p_to_org_id
205: BEGIN
206: -- bug 2958287
207: select intransit_time
208: into l_intransit_time
209: from msc_interorg_ship_methods
210: where plan_id = -1
211: and from_organization_id = p_from_org_id
212: and sr_instance_id = p_from_org_instance_id
213: and to_organization_id = p_to_org_id
229: BEGIN
230: -- bug 2958287
231: select intransit_time
232: into l_intransit_time
233: from msc_interorg_ship_methods
234: where plan_id = -1
235: and from_organization_id = p_from_org_id
236: and sr_instance_id = p_from_org_instance_id
237: and to_organization_id = p_to_org_id
266: BEGIN
267: -- bug 2958287
268: select cost_per_weight_unit
269: into l_weight_cost
270: from msc_interorg_ship_methods
271: where plan_id = -1
272: and from_organization_id = p_from_org_id
273: and sr_instance_id = p_from_org_instance_id
274: and to_organization_id = p_to_org_id
288: BEGIN
289: -- bug 2958287
290: select cost_per_weight_unit
291: into l_weight_cost
292: from msc_interorg_ship_methods
293: where plan_id = -1
294: and from_organization_id = p_from_org_id
295: and sr_instance_id = p_from_org_instance_id
296: and to_organization_id = p_to_org_id
324: BEGIN
325: -- bug 2958287
326: select transport_cap_over_util_cost
327: into l_transport_cost
328: from msc_interorg_ship_methods
329: where plan_id = -1
330: and from_organization_id = p_from_org_id
331: and sr_instance_id = p_from_org_instance_id
332: and to_organization_id = p_to_org_id
346: BEGIN
347: -- bug 2958287
348: select transport_cap_over_util_cost
349: into l_transport_cost
350: from msc_interorg_ship_methods
351: where plan_id = -1
352: and from_organization_id = p_from_org_id
353: and sr_instance_id = p_from_org_instance_id
354: and to_organization_id = p_to_org_id