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 785: FROM wsh_trip_stops wts,

781: SELECT wts.trip_id,
782: wdl.pick_up_stop_id,
783: wdl.drop_off_stop_id,
784: wdl.parent_delivery_leg_id
785: FROM wsh_trip_stops wts,
786: wsh_delivery_legs wdl
787: WHERE wdl.delivery_id = p_entity_id
788: AND wdl.pick_up_stop_id = wts.stop_id;
789:

Line 795: FROM wsh_trip_stops wts

791: SELECT wts.stop_id,
792: wts.departure_gross_weight,
793: wts.departure_net_weight,
794: wts.departure_volume
795: FROM wsh_trip_stops wts
796: WHERE wts.trip_id = c_trip_id
797: AND wts.stop_sequence_number < (
798: select wts1.stop_sequence_number
799: from wsh_trip_stops wts1

Line 799: from wsh_trip_stops wts1

795: FROM wsh_trip_stops wts
796: WHERE wts.trip_id = c_trip_id
797: AND wts.stop_sequence_number < (
798: select wts1.stop_sequence_number
799: from wsh_trip_stops wts1
800: where wts1.stop_id = c_dpoff_stop_id)
801: AND wts.stop_sequence_number >= (
802: select wts2.stop_sequence_number
803: from wsh_trip_stops wts2

Line 803: from wsh_trip_stops wts2

799: from wsh_trip_stops wts1
800: where wts1.stop_id = c_dpoff_stop_id)
801: AND wts.stop_sequence_number >= (
802: select wts2.stop_sequence_number
803: from wsh_trip_stops wts2
804: where wts2.stop_id = c_pkup_stop_id)
805: FOR UPDATE NOWAIT -- BugFix 3570954 Added NOWAIT
806: ORDER BY wts.stop_id, wts.planned_departure_date ASC;
807:

Line 929: FROM wsh_trip_stops

925: l_pick_up_weight,
926: l_pick_up_volume,
927: l_drop_off_weight,
928: l_drop_off_volume
929: FROM wsh_trip_stops
930: WHERE stop_id = p_entity_id
931: FOR UPDATE NOWAIT;
932: EXCEPTION
933: WHEN record_locked THEN

Line 1098: update wsh_trip_stops

1094: END IF;
1095: --R12 MDC
1096: --Included update for new wt/vol columns
1097: IF p_stop_type = 'DROPOFF' THEN
1098: update wsh_trip_stops
1099: set last_update_date = SYSDATE,
1100: last_updated_by = FND_GLOBAL.user_id,
1101: last_update_login = FND_GLOBAL.login_id,
1102: drop_off_weight = l_drop_off_weight,

Line 1107: update wsh_trip_stops

1103: drop_off_volume = l_drop_off_volume
1104: where stop_id = p_entity_id;
1105:
1106: ELSIF l_frozen_flag = 'Y' AND p_stop_type = 'PICKUP' THEN
1107: update wsh_trip_stops
1108: set last_update_date = SYSDATE,
1109: last_updated_by = FND_GLOBAL.user_id,
1110: last_update_login = FND_GLOBAL.login_id,
1111: pick_up_weight = l_pick_up_weight,

Line 1116: update wsh_trip_stops

1112: pick_up_volume = l_pick_up_volume
1113: where stop_id = p_entity_id;
1114: ELSIF NVL(l_frozen_flag, 'N') = 'N' THEN
1115: IF p_stop_type = 'PICKUP' THEN
1116: update wsh_trip_stops
1117: set departure_gross_weight = l_gross_weight,
1118: departure_net_weight = l_net_weight,
1119: departure_volume = l_volume,
1120: departure_fill_percent = l_fill_percent,

Line 1128: update wsh_trip_stops

1124: pick_up_weight = l_pick_up_weight,
1125: pick_up_volume = l_pick_up_volume
1126: where stop_id = p_entity_id;
1127: ELSE
1128: update wsh_trip_stops
1129: set departure_gross_weight = l_gross_weight,
1130: departure_net_weight = l_net_weight,
1131: departure_volume = l_volume,
1132: departure_fill_percent = l_fill_percent,

Line 2098: FROM wsh_trip_stops wts

2094: SELECT wts.stop_id,
2095: wts.departure_gross_weight,
2096: wts.departure_net_weight,
2097: wts.departure_volume
2098: FROM wsh_trip_stops wts
2099: WHERE wts.trip_id = c_trip_id
2100: AND wts.stop_sequence_number <= (
2101: select wts1.stop_sequence_number
2102: from wsh_trip_stops wts1

Line 2102: from wsh_trip_stops wts1

2098: FROM wsh_trip_stops wts
2099: WHERE wts.trip_id = c_trip_id
2100: AND wts.stop_sequence_number <= (
2101: select wts1.stop_sequence_number
2102: from wsh_trip_stops wts1
2103: where wts1.stop_id = c_dpoff_stop_id)
2104: AND wts.stop_sequence_number >= (
2105: select wts2.stop_sequence_number
2106: from wsh_trip_stops wts2

Line 2106: from wsh_trip_stops wts2

2102: from wsh_trip_stops wts1
2103: where wts1.stop_id = c_dpoff_stop_id)
2104: AND wts.stop_sequence_number >= (
2105: select wts2.stop_sequence_number
2106: from wsh_trip_stops wts2
2107: where wts2.stop_id = c_pkup_stop_id)
2108: FOR UPDATE NOWAIT
2109: ORDER BY wts.stop_id, wts.planned_departure_date ASC;
2110:

Line 2121: FROM wsh_trip_stops wts,

2117: SELECT wts.trip_id,
2118: wdl.pick_up_stop_id,
2119: wdl.drop_off_stop_id,
2120: wdl.parent_delivery_leg_id
2121: FROM wsh_trip_stops wts,
2122: wsh_delivery_legs wdl
2123: WHERE wdl.delivery_leg_id = p_leg_id
2124: AND wdl.pick_up_stop_id = wts.stop_id
2125: AND p_leg_id is not null

Line 2131: FROM wsh_trip_stops wts,

2127: SELECT wts.trip_id,
2128: wdl.pick_up_stop_id,
2129: wdl.drop_off_stop_id,
2130: wdl.parent_delivery_leg_id
2131: FROM wsh_trip_stops wts,
2132: wsh_delivery_legs wdl
2133: WHERE wdl.delivery_id = p_delivery_id
2134: AND wdl.pick_up_stop_id = wts.stop_id
2135: AND p_leg_id is null;

Line 2140: wsh_trip_stops wts

2136:
2137: CURSOR C1(c_trip_id IN NUMBER) IS
2138: SELECT delivery_id
2139: FROM wsh_delivery_legs wdl,
2140: wsh_trip_stops wts
2141: WHERE wts.trip_id = c_trip_id
2142: AND wdl.pick_up_stop_id = wts.stop_id
2143: AND wdl.parent_delivery_leg_id is NULL
2144: AND wdl.delivery_id <> p_delivery_id;

Line 2257: UPDATE wsh_trip_stops

2253: END IF;
2254:
2255: --R12 MDC
2256: --Included update for new wt/vol columns
2257: UPDATE wsh_trip_stops
2258: SET departure_gross_weight = null,
2259: departure_net_weight = null,
2260: departure_volume = null,
2261: departure_fill_percent = null,