APPS.MSC_SCATP_PUB dependencies on MSC_REGIONS_TEMP

Line 21: msc_regions_temp mrt

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
25: AND mism.to_region_id = mrt.region_id

Line 56: msc_regions_temp mrt

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
60: AND mism.to_region_id = mrt.region_id

Line 94: msc_regions_temp mrt

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
98: AND to_region_id = mrt.region_id

Line 129: msc_regions_temp mrt

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
133: AND to_region_id = mrt.region_id