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 700: NVL(tms_interface_flag,WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT), --OTM R12, glog proj

696: planned_flag,
697: shipment_direction,
698: delivery_type, -- MDC
699: NVL(ignore_for_planning, 'N'), --OTM R12, glog proj
700: NVL(tms_interface_flag,WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT), --OTM R12, glog proj
701: NULL -- --OTM R12,
702: FROM wsh_new_deliveries
703: WHERE delivery_id = v_del_id;
704:

Line 702: FROM wsh_new_deliveries

698: delivery_type, -- MDC
699: NVL(ignore_for_planning, 'N'), --OTM R12, glog proj
700: NVL(tms_interface_flag,WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT), --OTM R12, glog proj
701: NULL -- --OTM R12,
702: FROM wsh_new_deliveries
703: WHERE delivery_id = v_del_id;
704:
705: l_detail_rec WSH_DETAILS_VALIDATIONS.detail_rec_type;
706: l_del_rec WSH_DELIVERY_VALIDATIONS.dlvy_rec_type;

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

1004: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record and display warning
1005: IF p_in_rec.caller = 'PLSQL' THEN
1006: BEGIN
1007: SELECT 'Y',wt.name into l_status,l_name
1008: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,
1009: wsh_delivery_assignments wda, wsh_delivery_details wdd
1010: WHERE wt.trip_id = l_trip_id
1011: AND wts.trip_id = wt.trip_id
1012: AND wdl.pick_up_stop_id = wts.stop_id

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

1081: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record
1082: IF p_in_rec.caller = 'PLSQL' THEN
1083: BEGIN
1084: SELECT 'Y',wts.stop_location_id into l_status,l_stop_loc_id
1085: FROM wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,
1086: wsh_delivery_assignments wda, wsh_delivery_details wdd
1087: WHERE wts.stop_id = l_stop_id
1088: AND (wdl.pick_up_stop_id = wts.stop_id OR wdl.drop_off_stop_id = wts.stop_id)
1089: AND wnd.delivery_id = wdl.delivery_id

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

1158: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record
1159: IF p_in_rec.caller = 'PLSQL' THEN
1160: BEGIN
1161: SELECT 'Y',wnd.name into l_status,l_name
1162: FROM wsh_new_deliveries wnd, wsh_delivery_assignments wda, wsh_delivery_details wdd
1163: WHERE wnd.delivery_id = l_delivery_id
1164: AND wda.delivery_id = wnd.delivery_id
1165: AND wdd.delivery_detail_id = wda.delivery_detail_id
1166: AND wdd.oe_interfaced_flag = 'Y'

Line 1188: FROM wsh_new_deliveries

1184: --Bugfix 6816437 End
1185:
1186: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL)=1) THEN
1187: SELECT COUNT(*) INTO l_counts
1188: FROM wsh_new_deliveries
1189: WHERE delivery_id = l_delivery_id
1190: AND ROWNUM = 1;
1191:
1192: IF (l_counts = 0) THEN