DBA Data[Home] [Help]

APPS.MSC_ATP_FUNC dependencies on MSC_INTERORG_SHIP_METHODS

Line 904: FROM msc_interorg_ship_methods mism,

900: CURSOR c_lead_time
901: IS
902: SELECT intransit_time,
903: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
904: FROM msc_interorg_ship_methods mism,
905: msc_regions_temp mrt
906: WHERE mism.plan_id = -1
907: AND mism.from_location_id = p_from_location_id
908: AND mism.sr_instance_id = p_from_instance_id

Line 920: FROM msc_interorg_ship_methods

916: BEGIN
917: -- bug 2958287
918: SELECT intransit_time
919: INTO l_intransit_time
920: FROM msc_interorg_ship_methods
921: WHERE plan_id = -1
922: AND from_location_id = p_from_location_id
923: AND sr_instance_id = p_from_instance_id
924: AND to_location_id = p_to_location_id