eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_WV_UTILS dependencies on WSH_TRIP_STOPS

Line 780: FROM wsh_trip_stops wts,

776: SELECT wts.trip_id,
777: wdl.pick_up_stop_id,
778: wdl.drop_off_stop_id,
779: wdl.parent_delivery_leg_id
780: FROM wsh_trip_stops wts,
781: wsh_delivery_legs wdl
782: WHERE wdl.delivery_id = p_entity_id
783: AND wdl.pick_up_stop_id = wts.stop_id;
784:

Line 790: FROM wsh_trip_stops wts

786: SELECT wts.stop_id,
787: wts.departure_gross_weight,
788: wts.departure_net_weight,
789: wts.departure_volume
790: FROM wsh_trip_stops wts
791: WHERE wts.trip_id = c_trip_id
792: AND wts.stop_sequence_number < (
793: select wts1.stop_sequence_number
794: from wsh_trip_stops wts1

Line 794: from wsh_trip_stops wts1

790: FROM wsh_trip_stops wts
791: WHERE wts.trip_id = c_trip_id
792: AND wts.stop_sequence_number < (
793: select wts1.stop_sequence_number
794: from wsh_trip_stops wts1
795: where wts1.stop_id = c_dpoff_stop_id)
796: AND wts.stop_sequence_number >= (
797: select wts2.stop_sequence_number
798: from wsh_trip_stops wts2

Line 798: from wsh_trip_stops wts2

794: from wsh_trip_stops wts1
795: where wts1.stop_id = c_dpoff_stop_id)
796: AND wts.stop_sequence_number >= (
797: select wts2.stop_sequence_number
798: from wsh_trip_stops wts2
799: where wts2.stop_id = c_pkup_stop_id)
800: FOR UPDATE NOWAIT -- BugFix 3570954 Added NOWAIT
801: ORDER BY wts.stop_id, wts.planned_departure_date ASC;
802:

Line 924: FROM wsh_trip_stops

920: l_pick_up_weight,
921: l_pick_up_volume,
922: l_drop_off_weight,
923: l_drop_off_volume
924: FROM wsh_trip_stops
925: WHERE stop_id = p_entity_id
926: FOR UPDATE NOWAIT;
927: EXCEPTION
928: WHEN record_locked THEN

Line 1093: update wsh_trip_stops

1089: END IF;
1090: --R12 MDC
1091: --Included update for new wt/vol columns
1092: IF p_stop_type = 'DROPOFF' THEN
1093: update wsh_trip_stops
1094: set last_update_date = SYSDATE,
1095: last_updated_by = FND_GLOBAL.user_id,
1096: last_update_login = FND_GLOBAL.login_id,
1097: drop_off_weight = l_drop_off_weight,

Line 1102: update wsh_trip_stops

1098: drop_off_volume = l_drop_off_volume
1099: where stop_id = p_entity_id;
1100:
1101: ELSIF l_frozen_flag = 'Y' AND p_stop_type = 'PICKUP' THEN
1102: update wsh_trip_stops
1103: set last_update_date = SYSDATE,
1104: last_updated_by = FND_GLOBAL.user_id,
1105: last_update_login = FND_GLOBAL.login_id,
1106: pick_up_weight = l_pick_up_weight,

Line 1111: update wsh_trip_stops

1107: pick_up_volume = l_pick_up_volume
1108: where stop_id = p_entity_id;
1109: ELSIF NVL(l_frozen_flag, 'N') = 'N' THEN
1110: IF p_stop_type = 'PICKUP' THEN
1111: update wsh_trip_stops
1112: set departure_gross_weight = l_gross_weight,
1113: departure_net_weight = l_net_weight,
1114: departure_volume = l_volume,
1115: departure_fill_percent = l_fill_percent,

Line 1123: update wsh_trip_stops

1119: pick_up_weight = l_pick_up_weight,
1120: pick_up_volume = l_pick_up_volume
1121: where stop_id = p_entity_id;
1122: ELSE
1123: update wsh_trip_stops
1124: set departure_gross_weight = l_gross_weight,
1125: departure_net_weight = l_net_weight,
1126: departure_volume = l_volume,
1127: departure_fill_percent = l_fill_percent,

Line 2085: FROM wsh_trip_stops wts

2081: SELECT wts.stop_id,
2082: wts.departure_gross_weight,
2083: wts.departure_net_weight,
2084: wts.departure_volume
2085: FROM wsh_trip_stops wts
2086: WHERE wts.trip_id = c_trip_id
2087: AND wts.stop_sequence_number <= (
2088: select wts1.stop_sequence_number
2089: from wsh_trip_stops wts1

Line 2089: from wsh_trip_stops wts1

2085: FROM wsh_trip_stops wts
2086: WHERE wts.trip_id = c_trip_id
2087: AND wts.stop_sequence_number <= (
2088: select wts1.stop_sequence_number
2089: from wsh_trip_stops wts1
2090: where wts1.stop_id = c_dpoff_stop_id)
2091: AND wts.stop_sequence_number >= (
2092: select wts2.stop_sequence_number
2093: from wsh_trip_stops wts2

Line 2093: from wsh_trip_stops wts2

2089: from wsh_trip_stops wts1
2090: where wts1.stop_id = c_dpoff_stop_id)
2091: AND wts.stop_sequence_number >= (
2092: select wts2.stop_sequence_number
2093: from wsh_trip_stops wts2
2094: where wts2.stop_id = c_pkup_stop_id)
2095: FOR UPDATE NOWAIT
2096: ORDER BY wts.stop_id, wts.planned_departure_date ASC;
2097:

Line 2108: FROM wsh_trip_stops wts,

2104: SELECT wts.trip_id,
2105: wdl.pick_up_stop_id,
2106: wdl.drop_off_stop_id,
2107: wdl.parent_delivery_leg_id
2108: FROM wsh_trip_stops wts,
2109: wsh_delivery_legs wdl
2110: WHERE wdl.delivery_leg_id = p_leg_id
2111: AND wdl.pick_up_stop_id = wts.stop_id
2112: AND p_leg_id is not null

Line 2118: FROM wsh_trip_stops wts,

2114: SELECT wts.trip_id,
2115: wdl.pick_up_stop_id,
2116: wdl.drop_off_stop_id,
2117: wdl.parent_delivery_leg_id
2118: FROM wsh_trip_stops wts,
2119: wsh_delivery_legs wdl
2120: WHERE wdl.delivery_id = p_delivery_id
2121: AND wdl.pick_up_stop_id = wts.stop_id
2122: AND p_leg_id is null;

Line 2127: wsh_trip_stops wts

2123:
2124: CURSOR C1(c_trip_id IN NUMBER) IS
2125: SELECT delivery_id
2126: FROM wsh_delivery_legs wdl,
2127: wsh_trip_stops wts
2128: WHERE wts.trip_id = c_trip_id
2129: AND wdl.pick_up_stop_id = wts.stop_id
2130: AND wdl.parent_delivery_leg_id is NULL
2131: AND wdl.delivery_id <> p_delivery_id;

Line 2244: UPDATE wsh_trip_stops

2240: END IF;
2241:
2242: --R12 MDC
2243: --Included update for new wt/vol columns
2244: UPDATE wsh_trip_stops
2245: SET departure_gross_weight = null,
2246: departure_net_weight = null,
2247: departure_volume = null,
2248: departure_fill_percent = null,