APPS.WSH_FREIGHT_COSTS_GRP dependencies on WSH_DELIVERY_DETAILS

Line 714: FROM wsh_delivery_details

710: ship_from_location_id,
711: move_order_line_id, -- R12, X-dock project
712: NULL, -- OTM R12
713: client_id -- LSP PROJECT :Just added for dependency
714: FROM wsh_delivery_details
715: WHERE delivery_detail_id = v_detail_id;
716:
717: CURSOR c_trip_rec(v_trip_id NUMBER ) IS
718: SELECT trip_id,

Line 1055: wsh_delivery_assignments wda, wsh_delivery_details wdd

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
1059: AND wnd.delivery_id = wdl.delivery_id

Line 1132: wsh_delivery_assignments wda, wsh_delivery_details wdd

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
1136: AND wda.delivery_id = wnd.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 1274: FROM wsh_delivery_details

1270: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record
1271: IF p_in_rec.caller = 'PLSQL' THEN
1272: BEGIN
1273: SELECT container_flag,container_name into l_con_flag,l_name
1274: FROM wsh_delivery_details
1275: WHERE delivery_detail_id = l_freight_info_tab(l_index).delivery_detail_id;
1276:
1277: IF l_con_flag = 'Y' THEN
1278: l_entity_name := 'LPN';

Line 1280: FROM wsh_delivery_details

1276:
1277: IF l_con_flag = 'Y' THEN
1278: l_entity_name := 'LPN';
1279: SELECT 'Y' into l_status
1280: FROM wsh_delivery_details
1281: WHERE delivery_detail_id in (SELECT delivery_detail_id
1282: FROM wsh_delivery_assignments
1283: WHERE parent_delivery_detail_id = l_freight_info_tab(l_index).delivery_detail_id)
1284: AND oe_interfaced_flag = 'Y'

Line 1290: FROM wsh_delivery_details

1286: AND ROWNUM = 1;
1287: ELSE
1288: l_entity_name := 'Delivery line';
1289: SELECT oe_interfaced_flag,delivery_detail_id into l_status,l_name
1290: FROM wsh_delivery_details
1291: WHERE delivery_detail_id = l_freight_info_tab(l_index).delivery_detail_id;
1292: END IF;
1293:
1294: IF l_status = 'Y' THEN

Line 1314: FROM wsh_delivery_details

1310: --Bugfix 6816437 End
1311:
1312: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL)=1) THEN
1313: SELECT COUNT(delivery_detail_id) INTO l_counts
1314: FROM wsh_delivery_details
1315: WHERE delivery_detail_id = l_freight_info_tab(l_index).delivery_detail_id
1316: AND ROWNUM = 1;
1317:
1318: IF (l_counts = 0) THEN