DBA Data[Home] [Help]

APPS.INV_LABEL_PVT8 dependencies on WSH_DELIVERY_LEGS

Line 793: , wsh_delivery_legs wdl

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
797: WHERE wnd.delivery_id = wdl.delivery_id(+)

Line 798: AND wdi.entity_name (+) = 'WSH_DELIVERY_LEGS'

794: , wsh_document_instances wdi
795: , wsh_trip_stops wts
796: , wsh_trips wt
797: WHERE wnd.delivery_id = wdl.delivery_id(+)
798: AND wdi.entity_name (+) = 'WSH_DELIVERY_LEGS'
799: AND wdl.delivery_leg_id = wdi.entity_id (+)
800: AND wdl.pick_up_stop_id = wts.stop_id (+)
801: AND wts.trip_id = wt.trip_id (+)
802: AND wnd.delivery_id = p_delivery_id;