APPS.WSH_FTE_CONSTRAINT_FRAMEWORK dependencies on WSH_TRIPS

Line 9491: wsh_trips wt,

9487: wdl.sequence_number,wt.trip_id
9488: --#DUM_LOC(E)
9489: FROM wsh_new_deliveries wnd,
9490: wsh_delivery_legs wdl,
9491: wsh_trips wt,
9492: wsh_trip_stops wts1,
9493: wsh_trip_stops wts2
9494: WHERE wnd.delivery_id = c_delivery_id
9495: AND wdl.delivery_id = wnd.delivery_id

Line 11593: FROM wsh_trips where trip_id=l_tripid;

11589: CURSOR c_gettripdetails (l_tripid IN NUMBER) is
11590: SELECT TRIP_ID, 'Y'as EXISTS_IN_DATABASE, NAME, PLANNED_FLAG, STATUS_CODE, VEHICLE_ITEM_ID, VEHICLE_NUMBER,
11591: CARRIER_ID, SHIP_METHOD_CODE, VEHICLE_ORGANIZATION_ID, VEHICLE_NUM_PREFIX, SERVICE_LEVEL,
11592: MODE_OF_TRANSPORT
11593: FROM wsh_trips where trip_id=l_tripid;
11594:
11595: cursor c_gettrip(l_deliveryid IN NUMBER) is
11596: select wts.TRIP_ID
11597: from wsh_trip_stops wts, wsh_delivery_legs wdl

Line 16688: FROM wsh_trips wt, wsh_trip_stops wts

16684: CURSOR c_gettripdetails (l_stop_id IN NUMBER) is
16685: SELECT wt.TRIP_ID, 'Y'as exists_in_database, wt.NAME, wt.PLANNED_FLAG, wt.STATUS_CODE, wt.VEHICLE_ITEM_ID, wt.VEHICLE_NUMBER,
16686: wt.CARRIER_ID, wt.SHIP_METHOD_CODE, wt.VEHICLE_ORGANIZATION_ID, wt.VEHICLE_NUM_PREFIX, wt.SERVICE_LEVEL,
16687: wt.MODE_OF_TRANSPORT
16688: FROM wsh_trips wt, wsh_trip_stops wts
16689: WHERE wts.stop_id = l_stop_id
16690: AND wts.trip_id= wt.trip_id;
16691:
16692: CURSOR c_gettripinfo (l_trip_id IN NUMBER) is

Line 16696: FROM wsh_trips wt

16692: CURSOR c_gettripinfo (l_trip_id IN NUMBER) is
16693: SELECT wt.TRIP_ID, 'Y'as exists_in_database, wt.NAME, wt.PLANNED_FLAG, wt.STATUS_CODE, wt.VEHICLE_ITEM_ID, wt.VEHICLE_NUMBER,
16694: wt.CARRIER_ID, wt.SHIP_METHOD_CODE, wt.VEHICLE_ORGANIZATION_ID, wt.VEHICLE_NUM_PREFIX, wt.SERVICE_LEVEL,
16695: wt.MODE_OF_TRANSPORT
16696: FROM wsh_trips wt
16697: WHERE wt.trip_id = l_trip_id;
16698:
16699: CURSOR c_get_dlvy_stops(c_delivery_id IN NUMBER,c_trip_id IN NUMBER) IS
16700: SELECT wts1.stop_sequence_number pickup_stop_seq,