APPS.WSH_FREIGHT_COSTS_GRP dependencies on WSH_TRIPS

Line 280: l_db_col_rec WSH_TRIPS_PVT.trip_rec_type;

276: l_debug_on BOOLEAN;
277: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_DISABLED_LIST';
278:
279: l_disabled_list WSH_UTIL_CORE.column_tab_type;
280: l_db_col_rec WSH_TRIPS_PVT.trip_rec_type;
281: l_return_status VARCHAR2(30);
282: l_field_name VARCHAR2(100);
283:
284: CURSOR c_tbl_rec IS

Line 681: FROM wsh_trips

677: load_tender_status, -- R12 Select Carrier dependent change
678: lane_id,
679: shipments_type_flag,
680: NVL(ignore_for_planning, 'N') --OTM R12,glog proj
681: FROM wsh_trips
682: WHERE trip_id = v_trip_id;
683:
684: CURSOR c_stop_rec(v_stop_id NUMBER ) IS
685: SELECT stop_id,

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 1039: FROM wsh_trips

1035: --Bugfix 6816437 End
1036:
1037: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL)=1) THEN
1038: SELECT COUNT(*) INTO l_counts
1039: FROM wsh_trips
1040: WHERE trip_id = l_trip_id
1041: AND ROWNUM = 1;
1042:
1043: IF (l_counts = 0) THEN