APPS.WSH_PR_CRITERIA dependencies on WSH_PICKING_BATCHES

Line 844: FROM WSH_PICKING_BATCHES

840: NVL(ALLOCATION_METHOD,'I'), --anxsharm, X-dock
841: CROSSDOCK_CRITERIA_ID , --anxsharm, X-dock
842: DYNAMIC_REPLENISHMENT_FLAG, --bug# 6689448 (replenishment project)
843: NVL(CLIENT_ID, 0) --LSP PROJECT
844: FROM WSH_PICKING_BATCHES
845: WHERE BATCH_ID = v_batch_id;
846:
847: -- cursor to get batch parameter information
848: CURSOR get_lock_batch(v_batch_id IN NUMBER) IS

Line 907: FROM WSH_PICKING_BATCHES

903: NVL(ALLOCATION_METHOD,'I'), --anxsharm, X-dock
904: CROSSDOCK_CRITERIA_ID, --anxsharm, X-dock
905: DYNAMIC_REPLENISHMENT_FLAG, --bug# 6689448 (replenishment project)
906: NVL(CLIENT_ID, 0)
907: FROM WSH_PICKING_BATCHES
908: WHERE BATCH_ID = v_batch_id
909: FOR UPDATE OF BATCH_ID NOWAIT;
910:
911: -- cursor to get line information

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

934: -- Added condition AND CONTAINER_FLAG = 'Y' to fetch containers only.
935:
936: CURSOR get_batch_details (v_batch_id NUMBER, v_del_det NUMBER) IS
937: SELECT DELIVERY_DETAIL_ID -- If Launch PR from STF for del details, we stamp batch id
938: FROM WSH_DELIVERY_DETAILS -- on details. wsh_picking_batches has the detail as -1,
939: WHERE BATCH_ID = v_batch_id -- batch can have several delivery details
940: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO')
941: AND CONTAINER_FLAG='Y'
942: UNION

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

940: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO')
941: AND CONTAINER_FLAG='Y'
942: UNION
943: SELECT DELIVERY_DETAIL_ID -- If use PR form then we do not stamp batch id in wdd,
944: FROM WSH_DELIVERY_DETAILS -- wsh_picking_batches has the delivery detail stamped
945: WHERE DELIVERY_DETAIL_ID = v_del_det -- we can specify only one detail per batch
946: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO')
947: AND BATCH_ID IS NULL
948: AND CONTAINER_FLAG='Y';

Line 1466: UPDATE WSH_PICKING_BATCHES

1462: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING REQUEST ID FOR BATCH' );
1463: END IF;
1464:
1465: -- Update picking batch setting request id and other who parameters
1466: UPDATE WSH_PICKING_BATCHES
1467: SET REQUEST_ID = g_request_id,
1468: PROGRAM_APPLICATION_ID = g_application_id,
1469: PROGRAM_ID = g_program_id,
1470: PROGRAM_UPDATE_DATE = SYSDATE,