APPS.INV_LOC_WMS_UTILS dependencies on RCV_SUPPLY

Line 8621: FROM rcv_supply rs

8617: INTO l_chk_flag
8618: FROM dual
8619: WHERE EXISTS (
8620: SELECT 1
8621: FROM rcv_supply rs
8622: WHERE rs.to_locator_id = p_locator_id
8623: AND rs.to_organization_id = p_org_id
8624: AND rs.to_subinventory = p_subinventory
8625: AND rs.quantity > 0

Line 8637: FROM rcv_supply rs

8633: END IF;
8634:
8635: SELECT COUNT(DISTINCT item_id)
8636: INTO l_mixed_num
8637: FROM rcv_supply rs
8638: WHERE rs.to_locator_id = p_locator_id
8639: AND rs.to_organization_id = p_org_id
8640: AND rs.to_subinventory = p_subinventory
8641: AND rs.quantity > 0;