APPS.INV_LABEL_PVT8 dependencies on WSH_NEW_DELIVERIES

Line 889: FROM wsh_new_deliveries wnd

885: --, nvl(wnd.carrier_id, wt.carrier_id) wnd_carrier_id
886: , nvl(wt.carrier_id, wnd.carrier_id) wnd_carrier_id
887: , wnd.ship_method_code wnd_ship_method_code
888: , wnd.intmed_ship_to_location_id
889: FROM wsh_new_deliveries wnd
890: , wsh_delivery_legs wdl
891: , wsh_document_instances wdi
892: , wsh_trip_stops wts
893: , wsh_trips wt

Line 1645: FROM wsh_new_deliveries

1641: -- For non-WMS org, open different cursor
1642: IF l_delivery_id IS NOT NULL AND l_outer_lpn_id IS NULL THEN
1643: SELECT organization_id
1644: INTO l_organization_id
1645: FROM wsh_new_deliveries
1646: WHERE delivery_id = l_delivery_id;
1647:
1648: IF wms_install.check_install
1649: (x_return_status => l_return_status,