DBA Data[Home] [Help]

APPS.WSH_PROCESS_INTERFACED_PKG dependencies on WSH_TRIP_STOPS_INTERFACE

Line 2083: FROM wsh_del_legs_interface wdli, wsh_trip_stops_interface wtsi

2079: IS
2080: SELECT wdli.delivery_leg_interface_id,
2081: wdli.pick_up_stop_interface_id,
2082: wdli.drop_off_stop_interface_id, wtsi.trip_interface_id
2083: FROM wsh_del_legs_interface wdli, wsh_trip_stops_interface wtsi
2084: WHERE wdli.delivery_interface_id = p_delivery_interface_id
2085: AND wdli.pick_up_stop_interface_id = wtsi.stop_interface_id
2086: AND wdli.INTERFACE_ACTION_CODE = '94X_INBOUND'
2087: AND wtsi.INTERFACE_ACTION_CODE = '94X_INBOUND';

Line 2129: DELETE wsh_trip_stops_interface

2125: DELETE wsh_freight_costs_interface
2126: WHERE delivery_leg_interface_id = ids_rec.delivery_leg_interface_id
2127: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2128:
2129: DELETE wsh_trip_stops_interface
2130: WHERE stop_interface_id IN
2131: (ids_rec.pick_up_stop_interface_id,
2132: ids_rec.drop_off_stop_interface_id
2133: )