APPS.INV_LABEL_PVT8 dependencies on WSH_NEW_DELIVERIES

Line 792: FROM wsh_new_deliveries wnd

788: --, nvl(wnd.carrier_id, wt.carrier_id) wnd_carrier_id
789: , nvl(wt.carrier_id, wnd.carrier_id) wnd_carrier_id
790: , wnd.ship_method_code wnd_ship_method_code
791: , wnd.intmed_ship_to_location_id
792: FROM wsh_new_deliveries wnd
793: , wsh_delivery_legs wdl
794: , wsh_document_instances wdi
795: , wsh_trip_stops wts
796: , wsh_trips wt

Line 1502: FROM wsh_new_deliveries

1498: -- For non-WMS org, open different cursor
1499: IF l_delivery_id IS NOT NULL AND l_outer_lpn_id IS NULL THEN
1500: SELECT organization_id
1501: INTO l_organization_id
1502: FROM wsh_new_deliveries
1503: WHERE delivery_id = l_delivery_id;
1504:
1505: IF wms_install.check_install
1506: (x_return_status => l_return_status,