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 16683: FROM wsh_trips wt, wsh_trip_stops wts

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

Line 16691: FROM wsh_trips wt

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