eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_MDC_PVT dependencies on WSH_NEW_DELIVERIES_OB_GRP_V

Line 24: wsh_new_deliveries_ob_grp_v wnd

20: SELECT wda.delivery_id
21: INTO l_delivery_id
22: FROM wsh_delivery_assignments wda,
23: wsh_delivery_details_ob_grp_v wdd,
24: wsh_new_deliveries_ob_grp_v wnd
25: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
26: AND wnd.delivery_id = wda.delivery_id
27: AND wnd.delivery_type = 'CONSOLIDATION'
28: AND wdd.lpn_id = p_lpn_id

Line 58: FROM wsh_new_deliveries_ob_grp_v wnd

54: END IF;
55:
56: SELECT wnd.delivery_type
57: INTO l_delivery_type
58: FROM wsh_new_deliveries_ob_grp_v wnd
59: WHERE wnd.delivery_id = p_delivery_id ;
60:
61: IF g_debug = 1 THEN
62: debug('Consol l_delivery_type : ' || l_delivery_type,

Line 956: , wsh_new_deliveries_ob_grp_v d

952: AND wda.delivery_id IN (SELECT l2.delivery_id
953: FROM wsh_delivery_legs_ob_grp_v l1
954: , wsh_delivery_legs_ob_grp_v l2
955: , wsh_trip_stops_ob_grp_v s
956: , wsh_new_deliveries_ob_grp_v d
957: WHERE d.delivery_id = l_from_delivery_id
958: AND d.initial_pickup_location_id = s.stop_location_id
959: AND d.delivery_id = l1.delivery_id
960: AND s.stop_id = l1.pick_up_stop_id