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_FREIGHT_COSTS_GRP dependencies on WSH_NEW_DELIVERIES

Line 745: NVL(tms_interface_flag,WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT), --OTM R12, glog proj

741: planned_flag,
742: shipment_direction,
743: delivery_type, -- MDC
744: NVL(ignore_for_planning, 'N'), --OTM R12, glog proj
745: NVL(tms_interface_flag,WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT), --OTM R12, glog proj
746: NULL, -- --OTM R12,
747: client_id -- LSP PROJECT : Just added for dependency.
748: FROM wsh_new_deliveries
749: WHERE delivery_id = v_del_id;

Line 748: FROM wsh_new_deliveries

744: NVL(ignore_for_planning, 'N'), --OTM R12, glog proj
745: NVL(tms_interface_flag,WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT), --OTM R12, glog proj
746: NULL, -- --OTM R12,
747: client_id -- LSP PROJECT : Just added for dependency.
748: FROM wsh_new_deliveries
749: WHERE delivery_id = v_del_id;
750:
751: l_detail_rec WSH_DETAILS_VALIDATIONS.detail_rec_type;
752: l_del_rec WSH_DELIVERY_VALIDATIONS.dlvy_rec_type;

Line 1054: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,

1050: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record and display warning
1051: IF p_in_rec.caller = 'PLSQL' THEN
1052: BEGIN
1053: SELECT 'Y',wt.name into l_status,l_name
1054: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,
1055: wsh_delivery_assignments wda, wsh_delivery_details wdd
1056: WHERE wt.trip_id = l_trip_id
1057: AND wts.trip_id = wt.trip_id
1058: AND wdl.pick_up_stop_id = wts.stop_id

Line 1131: FROM wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,

1127: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record
1128: IF p_in_rec.caller = 'PLSQL' THEN
1129: BEGIN
1130: SELECT 'Y',wts.stop_location_id into l_status,l_stop_loc_id
1131: FROM wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,
1132: wsh_delivery_assignments wda, wsh_delivery_details wdd
1133: WHERE wts.stop_id = l_stop_id
1134: AND (wdl.pick_up_stop_id = wts.stop_id OR wdl.drop_off_stop_id = wts.stop_id)
1135: AND wnd.delivery_id = wdl.delivery_id

Line 1208: FROM wsh_new_deliveries wnd, wsh_delivery_assignments wda, wsh_delivery_details wdd

1204: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record
1205: IF p_in_rec.caller = 'PLSQL' THEN
1206: BEGIN
1207: SELECT 'Y',wnd.name into l_status,l_name
1208: FROM wsh_new_deliveries wnd, wsh_delivery_assignments wda, wsh_delivery_details wdd
1209: WHERE wnd.delivery_id = l_delivery_id
1210: AND wda.delivery_id = wnd.delivery_id
1211: AND wdd.delivery_detail_id = wda.delivery_detail_id
1212: AND wdd.oe_interfaced_flag = 'Y'

Line 1234: FROM wsh_new_deliveries

1230: --Bugfix 6816437 End
1231:
1232: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL)=1) THEN
1233: SELECT COUNT(*) INTO l_counts
1234: FROM wsh_new_deliveries
1235: WHERE delivery_id = l_delivery_id
1236: AND ROWNUM = 1;
1237:
1238: IF (l_counts = 0) THEN