DBA Data[Home] [Help]

APPS.WSH_TRIPS_ACTIONS dependencies on WSH_TRIP_STOPS

Line 28: STOP_ID wsh_trip_stops.stop_id%TYPE

24:
25: TYPE cs_trip_tab_type IS TABLE OF cs_trip_rec_type INDEX BY BINARY_INTEGER;
26:
27: TYPE cs_stop_rec_type IS RECORD (
28: STOP_ID wsh_trip_stops.stop_id%TYPE
29: , TRIP_ID wsh_trip_stops.trip_id%TYPE
30: --To handle dummy locations #DUM_LOC(S)
31: , STOP_LOCATION_ID wsh_trip_stops.stop_location_id%TYPE
32: , STATUS_CODE wsh_trip_stops.STATUS_CODE%TYPE

Line 29: , TRIP_ID wsh_trip_stops.trip_id%TYPE

25: TYPE cs_trip_tab_type IS TABLE OF cs_trip_rec_type INDEX BY BINARY_INTEGER;
26:
27: TYPE cs_stop_rec_type IS RECORD (
28: STOP_ID wsh_trip_stops.stop_id%TYPE
29: , TRIP_ID wsh_trip_stops.trip_id%TYPE
30: --To handle dummy locations #DUM_LOC(S)
31: , STOP_LOCATION_ID wsh_trip_stops.stop_location_id%TYPE
32: , STATUS_CODE wsh_trip_stops.STATUS_CODE%TYPE
33: , STOP_SEQUENCE_NUMBER wsh_trip_stops.STOP_SEQUENCE_NUMBER%TYPE

Line 31: , STOP_LOCATION_ID wsh_trip_stops.stop_location_id%TYPE

27: TYPE cs_stop_rec_type IS RECORD (
28: STOP_ID wsh_trip_stops.stop_id%TYPE
29: , TRIP_ID wsh_trip_stops.trip_id%TYPE
30: --To handle dummy locations #DUM_LOC(S)
31: , STOP_LOCATION_ID wsh_trip_stops.stop_location_id%TYPE
32: , STATUS_CODE wsh_trip_stops.STATUS_CODE%TYPE
33: , STOP_SEQUENCE_NUMBER wsh_trip_stops.STOP_SEQUENCE_NUMBER%TYPE
34: , PLANNED_ARRIVAL_DATE wsh_trip_stops.PLANNED_ARRIVAL_DATE%TYPE
35: , PLANNED_DEPARTURE_DATE wsh_trip_stops.PLANNED_DEPARTURE_DATE%TYPE

Line 32: , STATUS_CODE wsh_trip_stops.STATUS_CODE%TYPE

28: STOP_ID wsh_trip_stops.stop_id%TYPE
29: , TRIP_ID wsh_trip_stops.trip_id%TYPE
30: --To handle dummy locations #DUM_LOC(S)
31: , STOP_LOCATION_ID wsh_trip_stops.stop_location_id%TYPE
32: , STATUS_CODE wsh_trip_stops.STATUS_CODE%TYPE
33: , STOP_SEQUENCE_NUMBER wsh_trip_stops.STOP_SEQUENCE_NUMBER%TYPE
34: , PLANNED_ARRIVAL_DATE wsh_trip_stops.PLANNED_ARRIVAL_DATE%TYPE
35: , PLANNED_DEPARTURE_DATE wsh_trip_stops.PLANNED_DEPARTURE_DATE%TYPE
36: , ACTUAL_ARRIVAL_DATE wsh_trip_stops.ACTUAL_ARRIVAL_DATE%TYPE

Line 33: , STOP_SEQUENCE_NUMBER wsh_trip_stops.STOP_SEQUENCE_NUMBER%TYPE

29: , TRIP_ID wsh_trip_stops.trip_id%TYPE
30: --To handle dummy locations #DUM_LOC(S)
31: , STOP_LOCATION_ID wsh_trip_stops.stop_location_id%TYPE
32: , STATUS_CODE wsh_trip_stops.STATUS_CODE%TYPE
33: , STOP_SEQUENCE_NUMBER wsh_trip_stops.STOP_SEQUENCE_NUMBER%TYPE
34: , PLANNED_ARRIVAL_DATE wsh_trip_stops.PLANNED_ARRIVAL_DATE%TYPE
35: , PLANNED_DEPARTURE_DATE wsh_trip_stops.PLANNED_DEPARTURE_DATE%TYPE
36: , ACTUAL_ARRIVAL_DATE wsh_trip_stops.ACTUAL_ARRIVAL_DATE%TYPE
37: , ACTUAL_DEPARTURE_DATE wsh_trip_stops.ACTUAL_DEPARTURE_DATE%TYPE

Line 34: , PLANNED_ARRIVAL_DATE wsh_trip_stops.PLANNED_ARRIVAL_DATE%TYPE

30: --To handle dummy locations #DUM_LOC(S)
31: , STOP_LOCATION_ID wsh_trip_stops.stop_location_id%TYPE
32: , STATUS_CODE wsh_trip_stops.STATUS_CODE%TYPE
33: , STOP_SEQUENCE_NUMBER wsh_trip_stops.STOP_SEQUENCE_NUMBER%TYPE
34: , PLANNED_ARRIVAL_DATE wsh_trip_stops.PLANNED_ARRIVAL_DATE%TYPE
35: , PLANNED_DEPARTURE_DATE wsh_trip_stops.PLANNED_DEPARTURE_DATE%TYPE
36: , ACTUAL_ARRIVAL_DATE wsh_trip_stops.ACTUAL_ARRIVAL_DATE%TYPE
37: , ACTUAL_DEPARTURE_DATE wsh_trip_stops.ACTUAL_DEPARTURE_DATE%TYPE
38: --DUM_LOC(S)

Line 35: , PLANNED_DEPARTURE_DATE wsh_trip_stops.PLANNED_DEPARTURE_DATE%TYPE

31: , STOP_LOCATION_ID wsh_trip_stops.stop_location_id%TYPE
32: , STATUS_CODE wsh_trip_stops.STATUS_CODE%TYPE
33: , STOP_SEQUENCE_NUMBER wsh_trip_stops.STOP_SEQUENCE_NUMBER%TYPE
34: , PLANNED_ARRIVAL_DATE wsh_trip_stops.PLANNED_ARRIVAL_DATE%TYPE
35: , PLANNED_DEPARTURE_DATE wsh_trip_stops.PLANNED_DEPARTURE_DATE%TYPE
36: , ACTUAL_ARRIVAL_DATE wsh_trip_stops.ACTUAL_ARRIVAL_DATE%TYPE
37: , ACTUAL_DEPARTURE_DATE wsh_trip_stops.ACTUAL_DEPARTURE_DATE%TYPE
38: --DUM_LOC(S)
39: , PHYSICAL_LOCATION_ID wsh_trip_stops.PHYSICAL_LOCATION_ID%TYPE

Line 36: , ACTUAL_ARRIVAL_DATE wsh_trip_stops.ACTUAL_ARRIVAL_DATE%TYPE

32: , STATUS_CODE wsh_trip_stops.STATUS_CODE%TYPE
33: , STOP_SEQUENCE_NUMBER wsh_trip_stops.STOP_SEQUENCE_NUMBER%TYPE
34: , PLANNED_ARRIVAL_DATE wsh_trip_stops.PLANNED_ARRIVAL_DATE%TYPE
35: , PLANNED_DEPARTURE_DATE wsh_trip_stops.PLANNED_DEPARTURE_DATE%TYPE
36: , ACTUAL_ARRIVAL_DATE wsh_trip_stops.ACTUAL_ARRIVAL_DATE%TYPE
37: , ACTUAL_DEPARTURE_DATE wsh_trip_stops.ACTUAL_DEPARTURE_DATE%TYPE
38: --DUM_LOC(S)
39: , PHYSICAL_LOCATION_ID wsh_trip_stops.PHYSICAL_LOCATION_ID%TYPE
40: --#DUM_LOC(E)

Line 37: , ACTUAL_DEPARTURE_DATE wsh_trip_stops.ACTUAL_DEPARTURE_DATE%TYPE

33: , STOP_SEQUENCE_NUMBER wsh_trip_stops.STOP_SEQUENCE_NUMBER%TYPE
34: , PLANNED_ARRIVAL_DATE wsh_trip_stops.PLANNED_ARRIVAL_DATE%TYPE
35: , PLANNED_DEPARTURE_DATE wsh_trip_stops.PLANNED_DEPARTURE_DATE%TYPE
36: , ACTUAL_ARRIVAL_DATE wsh_trip_stops.ACTUAL_ARRIVAL_DATE%TYPE
37: , ACTUAL_DEPARTURE_DATE wsh_trip_stops.ACTUAL_DEPARTURE_DATE%TYPE
38: --DUM_LOC(S)
39: , PHYSICAL_LOCATION_ID wsh_trip_stops.PHYSICAL_LOCATION_ID%TYPE
40: --#DUM_LOC(E)
41: , PHYSICAL_STOP_ID wsh_trip_stops.PHYSICAL_STOP_ID%TYPE

Line 39: , PHYSICAL_LOCATION_ID wsh_trip_stops.PHYSICAL_LOCATION_ID%TYPE

35: , PLANNED_DEPARTURE_DATE wsh_trip_stops.PLANNED_DEPARTURE_DATE%TYPE
36: , ACTUAL_ARRIVAL_DATE wsh_trip_stops.ACTUAL_ARRIVAL_DATE%TYPE
37: , ACTUAL_DEPARTURE_DATE wsh_trip_stops.ACTUAL_DEPARTURE_DATE%TYPE
38: --DUM_LOC(S)
39: , PHYSICAL_LOCATION_ID wsh_trip_stops.PHYSICAL_LOCATION_ID%TYPE
40: --#DUM_LOC(E)
41: , PHYSICAL_STOP_ID wsh_trip_stops.PHYSICAL_STOP_ID%TYPE
42: , pick_up_weight wsh_trip_stops.pick_up_weight%TYPE
43: , weight_uom_code wsh_trip_stops.weight_uom_code%TYPE

Line 41: , PHYSICAL_STOP_ID wsh_trip_stops.PHYSICAL_STOP_ID%TYPE

37: , ACTUAL_DEPARTURE_DATE wsh_trip_stops.ACTUAL_DEPARTURE_DATE%TYPE
38: --DUM_LOC(S)
39: , PHYSICAL_LOCATION_ID wsh_trip_stops.PHYSICAL_LOCATION_ID%TYPE
40: --#DUM_LOC(E)
41: , PHYSICAL_STOP_ID wsh_trip_stops.PHYSICAL_STOP_ID%TYPE
42: , pick_up_weight wsh_trip_stops.pick_up_weight%TYPE
43: , weight_uom_code wsh_trip_stops.weight_uom_code%TYPE
44: , pick_up_volume wsh_trip_stops.pick_up_volume%TYPE
45: , volume_uom_code wsh_trip_stops.volume_uom_code%TYPE

Line 42: , pick_up_weight wsh_trip_stops.pick_up_weight%TYPE

38: --DUM_LOC(S)
39: , PHYSICAL_LOCATION_ID wsh_trip_stops.PHYSICAL_LOCATION_ID%TYPE
40: --#DUM_LOC(E)
41: , PHYSICAL_STOP_ID wsh_trip_stops.PHYSICAL_STOP_ID%TYPE
42: , pick_up_weight wsh_trip_stops.pick_up_weight%TYPE
43: , weight_uom_code wsh_trip_stops.weight_uom_code%TYPE
44: , pick_up_volume wsh_trip_stops.pick_up_volume%TYPE
45: , volume_uom_code wsh_trip_stops.volume_uom_code%TYPE
46: );

Line 43: , weight_uom_code wsh_trip_stops.weight_uom_code%TYPE

39: , PHYSICAL_LOCATION_ID wsh_trip_stops.PHYSICAL_LOCATION_ID%TYPE
40: --#DUM_LOC(E)
41: , PHYSICAL_STOP_ID wsh_trip_stops.PHYSICAL_STOP_ID%TYPE
42: , pick_up_weight wsh_trip_stops.pick_up_weight%TYPE
43: , weight_uom_code wsh_trip_stops.weight_uom_code%TYPE
44: , pick_up_volume wsh_trip_stops.pick_up_volume%TYPE
45: , volume_uom_code wsh_trip_stops.volume_uom_code%TYPE
46: );
47:

Line 44: , pick_up_volume wsh_trip_stops.pick_up_volume%TYPE

40: --#DUM_LOC(E)
41: , PHYSICAL_STOP_ID wsh_trip_stops.PHYSICAL_STOP_ID%TYPE
42: , pick_up_weight wsh_trip_stops.pick_up_weight%TYPE
43: , weight_uom_code wsh_trip_stops.weight_uom_code%TYPE
44: , pick_up_volume wsh_trip_stops.pick_up_volume%TYPE
45: , volume_uom_code wsh_trip_stops.volume_uom_code%TYPE
46: );
47:
48: TYPE cs_stop_tab_type IS TABLE OF cs_stop_rec_type INDEX BY BINARY_INTEGER;

Line 45: , volume_uom_code wsh_trip_stops.volume_uom_code%TYPE

41: , PHYSICAL_STOP_ID wsh_trip_stops.PHYSICAL_STOP_ID%TYPE
42: , pick_up_weight wsh_trip_stops.pick_up_weight%TYPE
43: , weight_uom_code wsh_trip_stops.weight_uom_code%TYPE
44: , pick_up_volume wsh_trip_stops.pick_up_volume%TYPE
45: , volume_uom_code wsh_trip_stops.volume_uom_code%TYPE
46: );
47:
48: TYPE cs_stop_tab_type IS TABLE OF cs_stop_rec_type INDEX BY BINARY_INTEGER;
49: