[Home] [Help]
80: -- used for bulk fetch.
81:
82: TYPE lpn_name_tab IS TABLE OF WMS_LICENSE_PLATE_NUMBERS.LICENSE_PLATE_NUMBER%TYPE
83: INDEX BY BINARY_INTEGER;
84: TYPE sub_name_tab IS TABLE OF MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE
85: INDEX BY BINARY_INTEGER;
86: TYPE row_type_tab IS TABLE OF WMS_PUTAWAY_GROUP_TASKS_GTMP.ROW_TYPE%TYPE
87: INDEX BY BINARY_INTEGER;
88: TYPE item_tab IS TABLE OF MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE
184: -- Get teh subinventory type for the passed sub_code
185:
186: SELECT nvl(subinventory_type,1)
187: INTO l_sub_type
188: FROM mtl_secondary_inventories
189: WHERE organization_id = p_organization_id
190: AND secondary_inventory_name = p_subinventory_code;
191:
192: l_progress := '120';
3409: --,mtl_item_locations milk
3410: ,mtl_system_items_kfv msik
3411: ,mtl_txn_request_headers mtrh
3412: ,wms_license_plate_numbers wln
3413: --,mtl_secondary_inventories msi
3414: WHERE wdt.organization_id = p_org_id
3415: -- kajain
3416: -- added the decode since a lpn loaded by someone
3417: -- should be eligible to be dropped by some other user
4366: ,milk.dropping_order loc_dropping_order
4367: ,Nvl(msi.lpn_controlled_flag,2) lpn_controlled_flag
4368: FROM mtl_material_transactions_temp mmtt
4369: ,wms_license_plate_numbers wlpn
4370: ,mtl_secondary_inventories msi
4371: ,mtl_item_locations_kfv milk
4372: WHERE mmtt.transaction_temp_id = v_transaction_temp_id
4373: AND mmtt.cartonization_id = wlpn.lpn_id(+)
4374: AND NVL(mmtt.transfer_to_location,mmtt.locator_id) = milk.inventory_location_id(+)
8355: l_progress NUMBER;
8356: l_ret NUMBER;
8357: l_lpn_id NUMBER;
8358: p_parent_lpn_id NUMBER;
8359: l_lpn_sub mtl_secondary_inventories.secondary_inventory_name%TYPE;
8360: l_lpn_loc NUMBER;
8361: l_to_lpn_id NUMBER;
8362:
8363:
10353: l_serialized_item BOOLEAN; --Flag to indicate if the item is serialized
10354: l_group_id NUMBER; -- Group ID
10355: l_product_transaction_id NUMBER; --Product transaction id for complete_putaway
10356: l_item_id NUMBER; --Item ID for complete_putaway
10357: l_subinventory_code mtl_secondary_inventories.secondary_inventory_name%TYPE;
10358: l_locator_id NUMBER; --Locator for complete_putaway
10359: l_lpn_id NUMBER; --p_LPN_ID for complete_putaway???--check
10360: l_to_lpn_id NUMBER; --To LPN ID -- for pack/unpack
10361: l_to_lpn_name wms_license_plate_numbers.license_plate_number%TYPE;
11136: SELECT NVL(lpn_controlled_flag, 1)
11137: , NVL(subinventory_type, 1)
11138: INTO l_lpn_controlled_flag
11139: , l_drop_sub_type
11140: FROM mtl_secondary_inventories
11141: WHERE organization_id = p_organization_id
11142: AND secondary_inventory_name = p_subinventory_code;
11143: EXCEPTION
11144: WHEN OTHERS THEN
12980:
12981: BEGIN
12982: SELECT lpn_controlled_flag,reservable_type,Nvl(subinventory_type,1)
12983: INTO l_lpn_controlled_flag,l_reservable_type,l_lpn_sub_type
12984: FROM mtl_secondary_inventories
12985: WHERE organization_id = p_organization_id
12986: AND secondary_inventory_name = l_into_lpn_sub
12987: AND ((Nvl(subinventory_type,1)=1 AND
12988: NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE))
13007: --If it is MANUAL_DROP, p_sub won't be passed
13008: BEGIN
13009: SELECT Nvl(subinventory_type,1)
13010: INTO l_sub_type
13011: FROM mtl_secondary_inventories
13012: WHERE organization_id = p_organization_id
13013: AND secondary_inventory_name = p_sub
13014: AND ((Nvl(subinventory_type,1)=1 AND
13015: NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE))