APPS.WSH_FTE_COMP_CONSTRAINT_GRP dependencies on WSH_TRIP_STOPS

Line 389: FROM wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_trips wt

385: SELECT
386: wts.TRIP_ID, 'Y'as EXISTS_IN_DATABASE, wt. NAME, wt.PLANNED_FLAG, wt.STATUS_CODE,
387: wt.VEHICLE_ITEM_ID, wt.VEHICLE_NUMBER, wt.CARRIER_ID, wt.SHIP_METHOD_CODE,
388: wt.VEHICLE_ORGANIZATION_ID, wt.VEHICLE_NUM_PREFIX, wt.SERVICE_LEVEL, wt.MODE_OF_TRANSPORT
389: FROM wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_trips wt
390: WHERE wdl.delivery_id = c_delivery_id
391: AND wdl.pick_up_stop_id = wts.stop_id
392: AND wts.trip_id = wt.trip_id;
393: