APPS.INV_RCV_COMMON_APIS dependencies on MTL_SECONDARY_INVENTORIES

Line 3137: FROM mtl_secondary_inventories msi

3133: INTO l_dummy
3134: FROM DUAL
3135: WHERE EXISTS(
3136: SELECT 1
3137: FROM mtl_secondary_inventories msi
3138: WHERE msi.organization_id = p_organization_id
3139: AND NVL(msi.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3140: AND msi.secondary_inventory_name = l_sub
3141: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, l_transaction_type, NULL, NULL, p_organization_id

Line 7536: l_sub_code mtl_secondary_inventories.secondary_inventory_name%TYPE;

7532: , p_organization_id IN NUMBER) IS
7533: l_count NUMBER;
7534: l_progress VARCHAR2(10);
7535: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7536: l_sub_code mtl_secondary_inventories.secondary_inventory_name%TYPE;
7537: l_locator_id NUMBER;
7538: l_location_id NUMBER;
7539: l_auto_transact_code VARCHAR2(10);
7540: BEGIN

Line 7572: --from hr_locations using location_id in mtl_secondary_inventories for that sub

7568: RETURN;
7569: END;
7570:
7571: --If the LPN has a subinventory associated, get the location_code
7572: --from hr_locations using location_id in mtl_secondary_inventories for that sub
7573: IF (l_debug = 1) THEN
7574: print_debug('get_rcv_sub_loc: 20: values from WLPN - context: ' || x_lpn_context ||
7575: ', sub_code: ' || l_sub_code || ', loc_id: ' || l_locator_id, 4);
7576: END IF;

Line 7658: FROM mtl_secondary_inventories msi

7654: , x_location_id
7655: from hr_locations hl
7656: WHERE EXISTS
7657: ( SELECT 1
7658: FROM mtl_secondary_inventories msi
7659: WHERE organization_id = p_organization_id
7660: AND secondary_inventory_name = l_sub_code
7661: AND msi.location_id = hl.location_id)
7662: AND ROWNUM = 1;