[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
183: -- Get teh subinventory type for the passed sub_code
184:
185: SELECT nvl(subinventory_type,1)
186: INTO l_sub_type
187: FROM mtl_secondary_inventories
188: WHERE organization_id = p_organization_id
189: AND secondary_inventory_name = p_subinventory_code;
190:
191: l_progress := '120';
2764: --,mtl_item_locations milk
2765: ,mtl_system_items_kfv msik
2766: ,mtl_txn_request_headers mtrh
2767: ,wms_license_plate_numbers wln
2768: --,mtl_secondary_inventories msi
2769: WHERE wdt.organization_id = p_org_id
2770: -- kajain
2771: -- added the decode since a lpn loaded by someone
2772: -- should be eligible to be dropped by some other user
3661: ,milk.dropping_order loc_dropping_order
3662: ,Nvl(msi.lpn_controlled_flag,2) lpn_controlled_flag
3663: FROM mtl_material_transactions_temp mmtt
3664: ,wms_license_plate_numbers wlpn
3665: ,mtl_secondary_inventories msi
3666: ,mtl_item_locations_kfv milk
3667: WHERE mmtt.transaction_temp_id = v_transaction_temp_id
3668: AND mmtt.cartonization_id = wlpn.lpn_id(+)
3669: AND NVL(mmtt.transfer_to_location,mmtt.locator_id) = milk.inventory_location_id(+)
7493: l_progress NUMBER;
7494: l_ret NUMBER;
7495: l_lpn_id NUMBER;
7496: p_parent_lpn_id NUMBER;
7497: l_lpn_sub mtl_secondary_inventories.secondary_inventory_name%TYPE;
7498: l_lpn_loc NUMBER;
7499: l_to_lpn_id NUMBER;
7500:
7501:
9481: l_serialized_item BOOLEAN; --Flag to indicate if the item is serialized
9482: l_group_id NUMBER; -- Group ID
9483: l_product_transaction_id NUMBER; --Product transaction id for complete_putaway
9484: l_item_id NUMBER; --Item ID for complete_putaway
9485: l_subinventory_code mtl_secondary_inventories.secondary_inventory_name%TYPE;
9486: l_locator_id NUMBER; --Locator for complete_putaway
9487: l_lpn_id NUMBER; --p_LPN_ID for complete_putaway???--check
9488: l_to_lpn_id NUMBER; --To LPN ID -- for pack/unpack
9489: l_to_lpn_name wms_license_plate_numbers.license_plate_number%TYPE;
10241: SELECT NVL(lpn_controlled_flag, 1)
10242: , NVL(subinventory_type, 1)
10243: INTO l_lpn_controlled_flag
10244: , l_drop_sub_type
10245: FROM mtl_secondary_inventories
10246: WHERE organization_id = p_organization_id
10247: AND secondary_inventory_name = p_subinventory_code;
10248: EXCEPTION
10249: WHEN OTHERS THEN
11879:
11880: BEGIN
11881: SELECT lpn_controlled_flag,reservable_type,Nvl(subinventory_type,1)
11882: INTO l_lpn_controlled_flag,l_reservable_type,l_lpn_sub_type
11883: FROM mtl_secondary_inventories
11884: WHERE organization_id = p_organization_id
11885: AND secondary_inventory_name = l_into_lpn_sub
11886: AND ((Nvl(subinventory_type,1)=1 AND
11887: NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE))
11906: --If it is MANUAL_DROP, p_sub won't be passed
11907: BEGIN
11908: SELECT Nvl(subinventory_type,1)
11909: INTO l_sub_type
11910: FROM mtl_secondary_inventories
11911: WHERE organization_id = p_organization_id
11912: AND secondary_inventory_name = p_sub
11913: AND ((Nvl(subinventory_type,1)=1 AND
11914: NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE))