[Home] [Help]
651: SELECT subinventory_code
652: , locator_id
653: INTO l_lpn_subinv
654: , l_lpn_locator_id
655: FROM wms_license_plate_numbers
656: WHERE lpn_id = p_lpn_id;
657:
658: -- If No Subinventory associated with LPN, then pick sub and locator from MMT
659: IF (l_lpn_subinv IS NULL) THEN
5064:
5065: -- Update the context of lpn to resides in receiving
5066: -- if it's a adj of whole lpn. lpn_id = transfer_lpn_id
5067: IF (p_lpn_id = p_transfer_lpn_id) THEN
5068: UPDATE wms_license_plate_numbers
5069: SET lpn_context = wms_container_pub.lpn_context_rcv
5070: WHERE lpn_id = p_lpn_id;
5071: END IF;
5072: ELSE
5168: -- LPN is in intransit state, that the LPN has non expense items in them
5169: IF ( v_cnt_lpn_ctx IS NULL ) THEN
5170: SELECT lpn_context
5171: INTO v_cnt_lpn_ctx
5172: FROM wms_license_plate_numbers
5173: WHERE lpn_id = p_content_lpn_id;
5174:
5175: IF (l_debug = 1) THEN
5176: inv_log_util.TRACE('Got v_cnt_lpn_ctx='||v_cnt_lpn_ctx, 'INV_LPN_TRX_PUB', 9);
5283:
5284: IF (p_lpn_id IS NULL
5285: AND p_transfer_lpn_id IS NOT NULL) THEN
5286: -- Change context of transfer lpn to recieving
5287: UPDATE wms_license_plate_numbers
5288: SET lpn_context = wms_container_pub.lpn_context_rcv
5289: , subinventory_code = nvl(l_sub,subinventory_code) --6374764
5290: , locator_id = nvl(l_loc_id,locator_id) --6374764
5291: WHERE lpn_id = p_transfer_lpn_id;
5338: , p_source_trx_id => p_source_transaction_id
5339: );
5340:
5341: -- Change context of transfer lpn to recieving
5342: UPDATE wms_license_plate_numbers
5343: SET lpn_context = wms_container_pub.lpn_context_rcv
5344: , subinventory_code = nvl(l_sub,subinventory_code) --6374764
5345: , locator_id = nvl(l_loc_id,locator_id) --6374764
5346: WHERE lpn_id = p_transfer_lpn_id;
5380: , cost_group_id = NULL
5381: WHERE parent_lpn_id = p_lpn_id;
5382:
5383: -- Change context of transfer lpn to recieving
5384: UPDATE wms_license_plate_numbers
5385: SET lpn_context = wms_container_pub.lpn_context_rcv
5386: , subinventory_code = nvl(l_sub,subinventory_code) --6374764
5387: , locator_id = nvl(l_loc_id,locator_id) --6374764
5388: WHERE lpn_id = p_lpn_id;
5479:
5480: -- Since correction is in same lpn, need to change context
5481: -- of lpn to recieving
5482: -- Change context of transfer lpn to recieving
5483: UPDATE wms_license_plate_numbers
5484: SET lpn_context = wms_container_pub.lpn_context_rcv
5485: WHERE lpn_id = p_lpn_id;
5486: END IF;
5487: ELSE
5771:
5772: -- Update the LPN status and location
5773: SELECT lpn_context
5774: INTO v_lpn_ctx
5775: FROM wms_license_plate_numbers
5776: WHERE lpn_id = v_lpn.lpn_id;
5777:
5778: IF (v_lpn_ctx <> wms_container_pub.lpn_context_picked) THEN
5779: v_lpn.lpn_context := wms_container_pub.lpn_context_inv;
5852: IF(p_transfer_lpn_id IS NOT NULL AND p_lpn_id IS NOT NULL) THEN
5853: IF ( v_lpn_ctx IS NULL ) THEN
5854: SELECT lpn_context
5855: INTO v_lpn_ctx
5856: FROM wms_license_plate_numbers
5857: WHERE lpn_id = p_lpn_id;
5858: END IF;
5859:
5860: IF (l_debug = 1) THEN
5891: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)) THEN
5892: -- Verify that the context of this LPN is 'Resides in Inventory'
5893: SELECT lpn_context
5894: INTO v_lpn_ctx
5895: FROM wms_license_plate_numbers
5896: WHERE lpn_id = p_lpn_id;
5897:
5898: IF (v_lpn_ctx <> wms_container_pub.lpn_context_inv
5899: AND v_lpn_ctx <> wms_container_pub.lpn_context_picked) THEN
5933: );
5934:
5935: --bug2747049
5936: IF (p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN
5937: UPDATE wms_license_plate_numbers
5938: SET lpn_context = v_lpn_ctx
5939: , subinventory_code = p_subinventory_code
5940: , locator_id = p_locator_id
5941: WHERE lpn_id = p_lpn_id
5996: IF (p_lpn_id IS NOT NULL) THEN
5997:
5998: SELECT lpn_context
5999: INTO l_lpn_ctx_tmp
6000: FROM wms_license_plate_numbers
6001: WHERE lpn_id = p_lpn_id;
6002:
6003: -- For Sub transfers reservations should be transfered
6004: -- for content lpn of who's context is not picked
6038: IF (p_content_lpn_id IS NOT NULL) THEN
6039: -- Update the LPN status and location
6040: SELECT lpn_context
6041: INTO v_cnt_lpn_ctx
6042: FROM wms_license_plate_numbers
6043: WHERE lpn_id = p_content_lpn_id;
6044:
6045: -- For Sub transfers reservations should be transfered
6046: -- for content lpn of who's context is not picked
6061: IF (l_debug = 1) THEN
6062: inv_log_util.TRACE('entered here cyclecount.. Bug#6043776','INV_LPN_TRX_PUB', 9);
6063: END IF;
6064: SELECT OUTERMOST_LPN_ID into l_cyclpn_id
6065: from wms_license_plate_numbers
6066: where lpn_id=p_content_lpn_id;
6067: END IF;
6068: /*End of Bug#6043776*/
6069:
6182: AND((NVL(p_lpn_id, 0) <> p_transfer_lpn_id)
6183: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)) THEN
6184: SELECT lpn_context
6185: INTO v_xfrlpn_ctx
6186: FROM wms_license_plate_numbers
6187: WHERE lpn_id = p_transfer_lpn_id;
6188:
6189: -- If the item/lpn is transfered to another LPN, then update the
6190: -- status of that LPN, provided the context is 2, 3, or 8
6332: IF (p_transaction_action_id = inv_globals.g_action_stgxfr
6333: AND p_lpn_id = p_transfer_lpn_id) THEN
6334: SELECT lpn_context
6335: INTO v_xfrlpn_ctx
6336: FROM wms_license_plate_numbers
6337: WHERE lpn_id = p_transfer_lpn_id;
6338:
6339: -- bug 5620764: add debug
6340: IF (l_debug = 1) THEN
6393: THEN
6394: IF (p_content_lpn_id IS NOT NULL) THEN
6395: SELECT lpn_context
6396: INTO v_cnt_lpn_ctx
6397: FROM wms_license_plate_numbers
6398: WHERE lpn_id = p_content_lpn_id;
6399:
6400: IF (l_debug = 1) THEN
6401: inv_log_util.TRACE('SUBXFER cont LPN context=' || v_cnt_lpn_ctx, 'INV_LPN_TRX_PUB', 9);
6462: -- It is possible that the LPN to which the packing is done could be in
6463: -- Receiving. However, after packing, the LPN has to be Inventory.
6464: -- Note: Since only the context of LPN is changed, directly modifying on Table
6465: -- instead of calling modify_LPN API except when the context is picking
6466: UPDATE wms_license_plate_numbers
6467: SET lpn_context = wms_container_pub.lpn_context_inv
6468: WHERE lpn_id = p_transfer_lpn_id
6469: AND lpn_context <> wms_container_pub.lpn_context_picked;
6470: /***** Actions for UNPACK transactions ****/
6505:
6506: IF (p_content_lpn_id IS NULL) THEN
6507: SELECT lpn_context
6508: INTO v_lpn_ctx
6509: FROM wms_license_plate_numbers
6510: WHERE lpn_id = p_lpn_id;
6511:
6512: IF (v_lpn_ctx = wms_container_pub.lpn_context_picked) THEN
6513: split_delivery(
6533: -- Note: Since only the context of LPN is changed, directly modifying on Table
6534: -- instead of calling modify_LPN API
6535: SELECT lpn_context
6536: INTO v_xfrlpn_ctx
6537: FROM wms_license_plate_numbers
6538: WHERE lpn_id = p_transfer_lpn_id;
6539:
6540: -- If context is pre-generated, then inherit the context of the contentLPN or fromLPN
6541: -- If that context is INV or PICKED
6616: p_transaction_action_id = inv_globals.G_Action_IntransitShipment))) then
6617: BEGIN
6618: UPDATE mtl_material_transactions_temp
6619: SET content_lpn_id = (SELECT outermost_lpn_id
6620: FROM wms_license_plate_numbers
6621: WHERE lpn_id = p_content_lpn_id
6622: AND rownum < 2)
6623: WHERE transaction_temp_id = p_transaction_temp_id;
6624: EXCEPTION