APPS.WSH_PR_CRITERIA dependencies on WSH_PICKING_BATCHES

Line 813: FROM WSH_PICKING_BATCHES

809: ACTUAL_DEPARTURE_DATE,
810: NVL(ALLOCATION_METHOD,'I'), --anxsharm, X-dock
811: CROSSDOCK_CRITERIA_ID , --anxsharm, X-dock
812: DYNAMIC_REPLENISHMENT_FLAG --bug# 6689448 (replenishment project)
813: FROM WSH_PICKING_BATCHES
814: WHERE BATCH_ID = v_batch_id;
815:
816: -- cursor to get batch parameter information
817: CURSOR get_lock_batch(v_batch_id IN NUMBER) IS

Line 875: FROM WSH_PICKING_BATCHES

871: ACTUAL_DEPARTURE_DATE,
872: NVL(ALLOCATION_METHOD,'I'), --anxsharm, X-dock
873: CROSSDOCK_CRITERIA_ID, --anxsharm, X-dock
874: DYNAMIC_REPLENISHMENT_FLAG --bug# 6689448 (replenishment project)
875: FROM WSH_PICKING_BATCHES
876: WHERE BATCH_ID = v_batch_id
877: FOR UPDATE OF BATCH_ID NOWAIT;
878:
879: -- cursor to get line information

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 1405: UPDATE WSH_PICKING_BATCHES

1401: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING REQUEST ID FOR BATCH' );
1402: END IF;
1403:
1404: -- Update picking batch setting request id and other who parameters
1405: UPDATE WSH_PICKING_BATCHES
1406: SET REQUEST_ID = g_request_id,
1407: PROGRAM_APPLICATION_ID = g_application_id,
1408: PROGRAM_ID = g_program_id,
1409: PROGRAM_UPDATE_DATE = SYSDATE,