DBA Data[Home] [Help]

APPS.WSH_PR_CRITERIA dependencies on WSH_DELIVERY_DETAILS

Line 258: FROM wsh_delivery_details

254: --All lines in SS are imported
255:
256: SELECT count(*)
257: INTO l_ss_count
258: FROM wsh_delivery_details
259: WHERE ship_set_id = p_ship_set_id
260: AND source_header_id = p_order_header_id
261: AND source_code = p_source_code
262: AND released_status IN ('R','N','B')

Line 337: FROM wsh_delivery_details

333: IF (l_status = FALSE) THEN
334: --Check for SMC with top_model_line_id
335: SELECT count(*)
336: INTO l_smc_count
337: FROM wsh_delivery_details
338: WHERE top_model_line_id = p_top_model_line_id
339: AND source_header_id = p_order_header_id
340: AND ship_model_complete_flag = 'Y'
341: AND source_code = p_source_code

Line 522: FROM WSH_DELIVERY_DETAILS

518: REQUESTED_QUANTITY_UOM,
519: SRC_REQUESTED_QUANTITY_UOM,
520: SRC_REQUESTED_QUANTITY,
521: INVENTORY_ITEM_ID
522: FROM WSH_DELIVERY_DETAILS
523: WHERE DELIVERY_DETAIL_ID = v_del_detail_id
524: AND RELEASED_STATUS IN ('R','B','X')
525: AND MOVE_ORDER_LINE_ID IS NULL
526: FOR UPDATE NOWAIT;

Line 559: FROM wsh_delivery_details wdd,

555: wdd.top_model_line_id,
556: wdd.ship_set_id,
557: wda.delivery_id,
558: wdd.last_update_date
559: FROM wsh_delivery_details wdd,
560: wsh_delivery_assignments_v wda
561: WHERE wdd.delivery_detail_id = v_del_detail_id
562: AND wda.delivery_detail_id = wdd.delivery_detail_id
563: AND wdd.date_scheduled IS NOT NULL

Line 889: WSH_DELIVERY_DETAILS WDD

885: -- cursor to get lines within a container
886: CURSOR get_inner_items (v_del_detail_id NUMBER) IS
887: SELECT WDD.DELIVERY_DETAIL_ID
888: FROM wsh_delivery_assignments_v WDA,
889: WSH_DELIVERY_DETAILS WDD
890: WHERE WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
891: AND WDD.CONTAINER_FLAG = 'N'
892: AND WDA.DELIVERY_ASSIGNMENT_ID IN
893: (SELECT WDA1.DELIVERY_ASSIGNMENT_ID

Line 906: FROM WSH_DELIVERY_DETAILS -- on details. wsh_picking_batches has the detail as -1,

902: -- Added condition AND CONTAINER_FLAG = 'Y' to fetch containers only.
903:
904: CURSOR get_batch_details (v_batch_id NUMBER, v_del_det NUMBER) IS
905: SELECT DELIVERY_DETAIL_ID -- If Launch PR from STF for del details, we stamp batch id
906: FROM WSH_DELIVERY_DETAILS -- on details. wsh_picking_batches has the detail as -1,
907: WHERE BATCH_ID = v_batch_id -- batch can have several delivery details
908: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO')
909: AND CONTAINER_FLAG='Y'
910: UNION

Line 912: FROM WSH_DELIVERY_DETAILS -- wsh_picking_batches has the delivery detail stamped

908: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO')
909: AND CONTAINER_FLAG='Y'
910: UNION
911: SELECT DELIVERY_DETAIL_ID -- If use PR form then we do not stamp batch id in wdd,
912: FROM WSH_DELIVERY_DETAILS -- wsh_picking_batches has the delivery detail stamped
913: WHERE DELIVERY_DETAIL_ID = v_del_det -- we can specify only one detail per batch
914: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO')
915: AND BATCH_ID IS NULL
916: AND CONTAINER_FLAG='Y';

Line 1240: UPDATE WSH_DELIVERY_DETAILS

1236: CLOSE get_inner_items;
1237:
1238: IF (g_det_lst.COUNT > 0) THEN
1239: FORALL i IN g_det_lst.FIRST..g_det_lst.LAST
1240: UPDATE WSH_DELIVERY_DETAILS
1241: SET BATCH_ID = p_batch_id
1242: WHERE DELIVERY_DETAIL_ID = g_det_lst(i);
1243: IF (SQL%ROWCOUNT > 0) THEN
1244: g_del_detail_id := -1;

Line 1979: 'u', ' FROM WSH_DELIVERY_DETAILS WDD,');

1975:
1976: -- 20. Common Tables to be selected irrespective of P_MODE parameter
1977: --{
1978: Process_Buffer(p_print_flag,
1979: 'u', ' FROM WSH_DELIVERY_DETAILS WDD,');
1980: Process_Buffer(p_print_flag,
1981: 'u', ' wsh_delivery_assignments_v WDA,');
1982:
1983: -- Bug 2040002: Need WSH_NEW_DELIVERIES under following conditions only

Line 2095: ||' WSH_DELIVERY_DETAILS WHERE BATCH_ID = :X_batch_id '

2091: IF (g_del_detail_id = -1 ) THEN
2092:
2093: Process_Buffer(p_print_flag,'c',' AND WDA.DELIVERY_DETAIL_ID IN '
2094: ||'( SELECT DELIVERY_DETAIL_ID FROM '
2095: ||' WSH_DELIVERY_DETAILS WHERE BATCH_ID = :X_batch_id '
2096: ||' AND CONTAINER_FLAG = ''N'')'); -- ,p_batch_id);
2097:
2098: ELSIF (g_del_detail_id <> 0) THEN
2099: Process_Buffer(p_print_flag,'c', ' AND WDA.DELIVERY_DETAIL_ID = :X_del_detail_id'); -- ,g_del_detail_id);

Line 3742: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

3738: -- HW OPMCONV - Added qty2
3739: l_requested_quantity2 := l_requested_quantity2 - l_result2;
3740:
3741: IF l_debug_on THEN
3742: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
3743: END IF;
3744:
3745: -- HW OPMCONV - Added l_requested_quantity2 and re-arranged parameters
3746:

Line 3747: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(

3743: END IF;
3744:
3745: -- HW OPMCONV - Added l_requested_quantity2 and re-arranged parameters
3746:
3747: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
3748: p_from_detail_id => v_delivery_detail_id,
3749: p_req_quantity => l_requested_quantity,
3750: x_new_detail_id => l_new_delivery_detail_id,
3751: p_req_quantity2 => l_requested_quantity2,