[Home] [Help]
2955: INTO l_dummy
2956: FROM DUAL
2957: WHERE EXISTS(
2958: SELECT 1
2959: FROM mtl_secondary_inventories msi
2960: WHERE msi.organization_id = p_organization_id
2961: AND NVL(msi.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2962: AND msi.secondary_inventory_name = l_sub
2963: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, l_transaction_type, NULL, NULL, p_organization_id
7000: , p_organization_id IN NUMBER) IS
7001: l_count NUMBER;
7002: l_progress VARCHAR2(10);
7003: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7004: l_sub_code mtl_secondary_inventories.secondary_inventory_name%TYPE;
7005: l_locator_id NUMBER;
7006: l_location_id NUMBER;
7007: l_auto_transact_code VARCHAR2(10);
7008: BEGIN
7036: RETURN;
7037: END;
7038:
7039: --If the LPN has a subinventory associated, get the location_code
7040: --from hr_locations using location_id in mtl_secondary_inventories for that sub
7041: IF (l_debug = 1) THEN
7042: print_debug('get_rcv_sub_loc: 20: values from WLPN - context: ' || x_lpn_context ||
7043: ', sub_code: ' || l_sub_code || ', loc_id: ' || l_locator_id, 4);
7044: END IF;
7122: , x_location_id
7123: from hr_locations hl
7124: WHERE EXISTS
7125: ( SELECT 1
7126: FROM mtl_secondary_inventories msi
7127: WHERE organization_id = p_organization_id
7128: AND secondary_inventory_name = l_sub_code
7129: AND msi.location_id = hl.location_id)
7130: AND ROWNUM = 1;