APPS.MSC_ATP_PROC dependencies on MTL_INTERORG_SHIP_METHODS

Line 4938: FROM mtl_interorg_ship_methods mism,

4934: CURSOR c_lead_time (c_from_loc_id number, c_partner_site_id number, c_session_id number)
4935: IS
4936: SELECT mism.ship_method, mism.intransit_time,
4937: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
4938: FROM mtl_interorg_ship_methods mism,
4939: msc_regions_temp mrt
4940: WHERE mism.from_location_id = c_from_loc_id
4941: AND mism.to_region_id = mrt.region_id
4942: AND mrt.session_id = c_session_id

Line 5183: from mtl_interorg_ship_methods

5179: -1,
5180: intransit_time,
5181: ship_method,
5182: 100
5183: from mtl_interorg_ship_methods
5184: where from_organization_id = p_from_organization_id
5185: and to_organization_id = p_to_organization_id
5186: );
5187: IF PG_DEBUG in ('Y', 'C') THEN

Line 5241: from mtl_interorg_ship_methods

5237: -1,
5238: intransit_time,
5239: ship_method,
5240: 100
5241: from mtl_interorg_ship_methods
5242: where from_location_id = l_from_location_id
5243: and to_location_id = l_to_location_id
5244: );
5245: EXCEPTION