APPS.INV_LOC_WMS_UTILS dependencies on RCV_SUPPLY

Line 8099: FROM rcv_supply rs

8095: INTO l_chk_flag
8096: FROM dual
8097: WHERE EXISTS (
8098: SELECT 1
8099: FROM rcv_supply rs
8100: WHERE rs.to_locator_id = p_locator_id
8101: AND rs.to_organization_id = p_org_id
8102: AND rs.to_subinventory = p_subinventory
8103: AND rs.quantity > 0

Line 8115: FROM rcv_supply rs

8111: END IF;
8112:
8113: SELECT COUNT(DISTINCT item_id)
8114: INTO l_mixed_num
8115: FROM rcv_supply rs
8116: WHERE rs.to_locator_id = p_locator_id
8117: AND rs.to_organization_id = p_org_id
8118: AND rs.to_subinventory = p_subinventory
8119: AND rs.quantity > 0;