APPS.WSH_FREIGHT_COSTS_GRP dependencies on WSH_DELIVERY_DETAILS

Line 669: FROM wsh_delivery_details

665: line_direction,
666: ship_from_location_id,
667: move_order_line_id, -- R12, X-dock project
668: NULL -- OTM R12
669: FROM wsh_delivery_details
670: WHERE delivery_detail_id = v_detail_id;
671:
672: CURSOR c_trip_rec(v_trip_id NUMBER ) IS
673: SELECT trip_id,

Line 1009: wsh_delivery_assignments wda, wsh_delivery_details wdd

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

Line 1086: wsh_delivery_assignments wda, wsh_delivery_details wdd

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

1224: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record
1225: IF p_in_rec.caller = 'PLSQL' THEN
1226: BEGIN
1227: SELECT container_flag,container_name into l_con_flag,l_name
1228: FROM wsh_delivery_details
1229: WHERE delivery_detail_id = l_freight_info_tab(l_index).delivery_detail_id;
1230:
1231: IF l_con_flag = 'Y' THEN
1232: l_entity_name := 'LPN';

Line 1234: FROM wsh_delivery_details

1230:
1231: IF l_con_flag = 'Y' THEN
1232: l_entity_name := 'LPN';
1233: SELECT 'Y' into l_status
1234: FROM wsh_delivery_details
1235: WHERE delivery_detail_id in (SELECT delivery_detail_id
1236: FROM wsh_delivery_assignments
1237: WHERE parent_delivery_detail_id = l_freight_info_tab(l_index).delivery_detail_id)
1238: AND oe_interfaced_flag = 'Y'

Line 1244: FROM wsh_delivery_details

1240: AND ROWNUM = 1;
1241: ELSE
1242: l_entity_name := 'Delivery line';
1243: SELECT oe_interfaced_flag,delivery_detail_id into l_status,l_name
1244: FROM wsh_delivery_details
1245: WHERE delivery_detail_id = l_freight_info_tab(l_index).delivery_detail_id;
1246: END IF;
1247:
1248: IF l_status = 'Y' THEN

Line 1268: FROM wsh_delivery_details

1264: --Bugfix 6816437 End
1265:
1266: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL)=1) THEN
1267: SELECT COUNT(delivery_detail_id) INTO l_counts
1268: FROM wsh_delivery_details
1269: WHERE delivery_detail_id = l_freight_info_tab(l_index).delivery_detail_id
1270: AND ROWNUM = 1;
1271:
1272: IF (l_counts = 0) THEN