DBA Data[Home] [Help]

APPS.INV_LABEL_PVT8 dependencies on WSH_DELIVERY_LEGS

Line 890: , wsh_delivery_legs wdl

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

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

891: , wsh_document_instances wdi
892: , wsh_trip_stops wts
893: , wsh_trips wt
894: WHERE wnd.delivery_id = wdl.delivery_id(+)
895: AND wdi.entity_name (+) = 'WSH_DELIVERY_LEGS'
896: AND wdl.delivery_leg_id = wdi.entity_id (+)
897: AND wdl.pick_up_stop_id = wts.stop_id (+)
898: AND wts.trip_id = wt.trip_id (+)
899: AND wnd.delivery_id = p_delivery_id;