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_PACKING_WORKBENCH_PVT dependencies on WSH_NEW_DELIVERIES_OB_GRP_V

Line 2015: FROM wsh_new_deliveries_ob_grp_v wnd

2011: -- Use this cursor when p_delivery_is is not null
2012: CURSOR l_delivery_cur_del IS
2013: SELECT wnd.delivery_id, wnd.name,
2014: nvl(p_delivery_state, wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id))
2015: FROM wsh_new_deliveries_ob_grp_v wnd
2016: WHERE wnd.organization_id = p_organization_id
2017: AND wnd.delivery_id = p_delivery_id
2018: AND ((p_trip_id IS NULL) OR
2019: (p_trip_id IS NOT NULL AND wnd.delivery_id IN

Line 2031: FROM wsh_new_deliveries_ob_grp_v wnd

2027: -- Use this cursor when p_delivery_is is null but p_trip_id is not null
2028: CURSOR l_delivery_cur_trip IS
2029: SELECT wnd.delivery_id, wnd.name,
2030: nvl(p_delivery_state, wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id))
2031: FROM wsh_new_deliveries_ob_grp_v wnd
2032: WHERE wnd.organization_id = p_organization_id
2033: AND wnd.delivery_id IN
2034: (select wdl.delivery_id from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts
2035: where wdl.pick_up_stop_id = wts.stop_id

Line 2046: FROM wsh_new_deliveries_ob_grp_v wnd

2042: -- Then have to use this expensive cursor
2043: CURSOR l_delivery_cur_exp IS
2044: SELECT wnd.delivery_id, wnd.name,
2045: nvl(p_delivery_state, wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id))
2046: FROM wsh_new_deliveries_ob_grp_v wnd
2047: WHERE wnd.organization_id = p_organization_id
2048: AND ((p_delivery_state IS NULL) OR
2049: (p_delivery_state IS NOT NULL AND
2050: wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id) = p_delivery_state));

Line 2081: ,wsh_delivery_assignments_v wda, wsh_new_deliveries_ob_grp_v wnd

2077: ,wdd1.ship_to_location_id
2078: ,wdd1.ship_set_id
2079: ,wdd1.top_model_line_id
2080: FROM wsh_delivery_details_ob_grp_v wdd1, wsh_delivery_details_ob_grp_v wdd2
2081: ,wsh_delivery_assignments_v wda, wsh_new_deliveries_ob_grp_v wnd
2082: -- Bug 5121507
2083: , wsh_delivery_legs wdl
2084: , wsh_trip_stops wts
2085: , wsh_trips wt