APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on MTL_INTERORG_SHIP_METHODS

Line 2635: from mtl_interorg_ship_methods

2631: --
2632: /*This Cursor gets transit time if transit time is defined between two locations */
2633: cursor get_Transit_Loc_Loc (p_from_loc_id NUMBER, p_to_loc_id NUMBER, p_ship_method VARCHAR2) IS
2634: select intransit_time
2635: from mtl_interorg_ship_methods
2636: where from_location_id = p_from_loc_id
2637: and to_location_id = p_to_loc_id
2638: and ship_method = p_ship_method_code;
2639:

Line 2643: FROM mtl_interorg_ship_methods

2639:
2640: /*This Cursor gets transit time if transit time is defined between FROM Region TO location */
2641: CURSOR get_Transit_Region_Loc (p_from_region_id NUMBER, p_to_loc_id NUMBER, p_ship_method VARCHAR2) IS
2642: SELECT intransit_time
2643: FROM mtl_interorg_ship_methods
2644: WHERE from_region_id = p_from_region_id
2645: AND to_location_id = p_to_loc_id
2646: AND ship_method = p_ship_method_code;
2647:

Line 2651: FROM mtl_interorg_ship_methods

2647:
2648: /*This Cursor gets transit time if transit time is defined between FROM Location TO region */
2649: CURSOR get_Transit_Loc_Region (p_from_loc_id NUMBER, p_to_region_id NUMBER, p_ship_method VARCHAR2) IS
2650: SELECT intransit_time
2651: FROM mtl_interorg_ship_methods
2652: WHERE from_location_id = p_from_loc_id
2653: AND to_region_id = p_to_region_id
2654: AND ship_method = p_ship_method_code;
2655:

Line 2659: FROM mtl_interorg_ship_methods

2655:
2656: /*This Cursor gets transit time if transit time is defined between FROM region TO region*/
2657: CURSOR get_Transit_Region_Region (p_from_region_id NUMBER, p_to_region_id NUMBER, p_ship_method VARCHAR2) IS
2658: SELECT intransit_time
2659: FROM mtl_interorg_ship_methods
2660: WHERE from_region_id = p_from_region_id
2661: AND to_region_id = p_to_region_id
2662: AND ship_method = p_ship_method_code;
2663: