DBA Data[Home] [Help]

APPS.MSC_ATP_FUNC dependencies on MSC_REGIONS_TEMP

Line 905: msc_regions_temp mrt

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
909: AND mism.sr_instance_id2 = p_to_instance_id