APPS.MSC_ATP_PROC dependencies on MTL_INTERORG_SHIP_METHODS

Line 4929: FROM mtl_interorg_ship_methods mism,

4925: CURSOR c_lead_time (c_from_loc_id number, c_partner_site_id number, c_session_id number)
4926: IS
4927: SELECT mism.ship_method, mism.intransit_time,
4928: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
4929: FROM mtl_interorg_ship_methods mism,
4930: msc_regions_temp mrt
4931: WHERE mism.from_location_id = c_from_loc_id
4932: AND mism.to_region_id = mrt.region_id
4933: AND mrt.session_id = c_session_id

Line 5174: from mtl_interorg_ship_methods

5170: -1,
5171: intransit_time,
5172: ship_method,
5173: 100
5174: from mtl_interorg_ship_methods
5175: where from_organization_id = p_from_organization_id
5176: and to_organization_id = p_to_organization_id
5177: );
5178: IF PG_DEBUG in ('Y', 'C') THEN

Line 5232: from mtl_interorg_ship_methods

5228: -1,
5229: intransit_time,
5230: ship_method,
5231: 100
5232: from mtl_interorg_ship_methods
5233: where from_location_id = l_from_location_id
5234: and to_location_id = l_to_location_id
5235: );
5236: EXCEPTION