APPS.WSH_MAPPING_DATA dependencies on WSH_DELIVERY_LEGS

Line 87: FROM wsh_delivery_legs wdl,

83: wt.Routing_Instructions,
84: wts1.Departure_Seal_Code,
85: --Bug 3458160
86: wt.operator
87: FROM wsh_delivery_legs wdl,
88: wsh_trip_stops wts1,
89: wsh_trip_stops wts2,
90: wsh_trips wt
91: WHERE wts1.trip_id = wt.trip_id

Line 1363: FROM wsh_delivery_legs wdl,

1359: wt.Route_ID,
1360: wt.Routing_Instructions,
1361: wts1.Departure_Seal_Code,
1362: wt.operator
1363: FROM wsh_delivery_legs wdl,
1364: wsh_trip_stops wts1,
1365: wsh_trip_stops wts2,
1366: wsh_trips wt
1367: WHERE wts1.trip_id = wt.trip_id

Line 1600: wsh_delivery_legs wdl,

1596:
1597: SELECT wdi.sequence_number
1598: INTO x_bill_of_lading_num
1599: FROM wsh_new_deliveries wnd,
1600: wsh_delivery_legs wdl,
1601: wsh_trip_stops wts,
1602: wsh_document_instances wdi
1603: WHERE wnd.delivery_id = p_delivery_id
1604: AND wnd.delivery_id = wdl.delivery_id

Line 1608: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'

1604: AND wnd.delivery_id = wdl.delivery_id
1605: AND wdl.pick_up_stop_id = wts.stop_id
1606: AND wts.stop_location_id = wnd.initial_pickup_location_id
1607: AND wdi.entity_id = wdl.delivery_leg_id
1608: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
1609: AND wdi.document_type = 'BOL';
1610:
1611: EXCEPTION
1612: WHEN OTHERS THEN