APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on MTL_INTERORG_SHIP_METHODS

Line 2651: from mtl_interorg_ship_methods

2647: --
2648: /*This Cursor gets transit time if transit time is defined between two locations */
2649: cursor get_Transit_Loc_Loc (p_from_loc_id NUMBER, p_to_loc_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_location_id = p_to_loc_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 location */
2657: CURSOR get_Transit_Region_Loc (p_from_region_id NUMBER, p_to_loc_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_location_id = p_to_loc_id
2662: AND ship_method = p_ship_method_code;
2663:

Line 2667: FROM mtl_interorg_ship_methods

2663:
2664: /*This Cursor gets transit time if transit time is defined between FROM Location TO region */
2665: CURSOR get_Transit_Loc_Region (p_from_loc_id NUMBER, p_to_region_id NUMBER, p_ship_method VARCHAR2) IS
2666: SELECT intransit_time
2667: FROM mtl_interorg_ship_methods
2668: WHERE from_location_id = p_from_loc_id
2669: AND to_region_id = p_to_region_id
2670: AND ship_method = p_ship_method_code;
2671:

Line 2675: FROM mtl_interorg_ship_methods

2671:
2672: /*This Cursor gets transit time if transit time is defined between FROM region TO region*/
2673: CURSOR get_Transit_Region_Region (p_from_region_id NUMBER, p_to_region_id NUMBER, p_ship_method VARCHAR2) IS
2674: SELECT intransit_time
2675: FROM mtl_interorg_ship_methods
2676: WHERE from_region_id = p_from_region_id
2677: AND to_region_id = p_to_region_id
2678: AND ship_method = p_ship_method_code;
2679: